SSAS Issue : Partial data showing up when I browse

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSAS Issue : Partial data showing up when I...

SSAS Issue : Partial data showing up when I browse

Rate Topic

Display Mode

Topic Options

Author

Message

nitula.v

Posted Wednesday, December 12, 2012 9:43 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, January 20, 2013 7:08 PM
Points: 2, Visits: 22

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

Koen Verbeeck

Posted Thursday, December 13, 2012 1:04 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 9,410, Visits: 6,495

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

nitula.v

Posted Thursday, December 13, 2012 2:38 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, January 20, 2013 7:08 PM
Points: 2, Visits: 22

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 »

Permissions