December 12, 2012 at 9:43 pm
Hi,
This could be a silly issue. I have a location dimension attached to my sales cube. When I browse the data, i see revenue against only 4 locations in my cube. However the dimension has more than 20 locations and the underlying fact and the dimension view has data for all those. However its not coming up in the cube.
This has run well for the past month and had failed only couple of days ago. I have reprocessed the cube but it doesn't seem to work.
Appreciate if anyone can guide me on this.
thanks
December 13, 2012 at 1:04 am
You're sure that each and every of those 20 locations has data?
Is there a filter somewhere? (either in the report, or in the data source view, or somewhere else?)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2012 at 2:38 pm
Yeah they do have it. Just found out that the dimension that gets populated have blanks in some of the fields whih are used for defining hierarchies. didn't knew that would cause the data to disappear for some locations
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply