SSAS 2008 and adding built in time dimension

View previous topic View next topic Go down

SSAS 2008 and adding built in time dimension

Post  DimFact on Tue Sep 20, 2011 1:16 pm

I added a time dimension to my SSAS cube. Then added it as a cube dimension. This was required in order to add year to date

functionality. Once this was in place I was able to add the time intelligence to the cube where it allowed for adding the ytd to

my calendar hierarchy. Everything was looking promising but when I viewed the cube in the browser, although the calendar drill down

hierarchy worked, and I performed the drilldowns the value #1 totals across all the selected years, quarters, months, days were exactly

the same. What did I miss?

DimFact

Posts : 3
Join date : 2011-09-11

View user profile

Back to top Go down

Re: SSAS 2008 and adding built in time dimension

Post  hang on Tue Sep 20, 2011 7:08 pm

On the dimension usage tab, make sure the time dimension is configured/selected for the related measures.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum