Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Issue : Partial data showing up when I browse Expand / Collapse
Author
Message
Posted Wednesday, December 12, 2012 9:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:48 PM
Points: 4, Visits: 47
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
Post #1395974
Posted Thursday, December 13, 2012 1:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 6:46 AM
Points: 13,646, Visits: 11,524
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?)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1396029
Posted Thursday, December 13, 2012 2:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:48 PM
Points: 4, Visits: 47
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
Post #1396406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse