January 28, 2009 at 6:56 am
I have designed cube which have 3 dimension and 1 fact table. I have records from year 1996 to till date , when I export cube to excel I am not able to view data after certain dates . What could be the reason . I haven't applied filter inside cube.
January 29, 2009 at 4:39 am
Are you able to see the data when you browse the cube within the browser tab in BIDS or when connected to the SSAS database with SSMS?
Are you just connecting to the cube to create pivottables and charts in Excel or have you actually created a local cube to connect to?
Have you verified all of the relationships within the dimension usage of the cube in BIDS to make sure that you have properly related the dimensions to the measure group?
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply