Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


SSAS 2008 and adding built in time dimension

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

SSAS 2008 and adding built in time dimension Empty SSAS 2008 and adding built in time dimension

Post  DimFact 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

Back to top Go down

SSAS 2008 and adding built in time dimension Empty Re: SSAS 2008 and adding built in time dimension

Post  hang 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

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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