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

Drill down in cubes

3 posters

Go down

Drill down in cubes Empty Drill down in cubes

Post  saneel.b Mon Oct 01, 2012 12:50 pm

I am new to using Microsoft SSAS. I have a Date dimension with hierarchy - Year -Month-Day ; and Time Dimension with
hierarchy - Hour Minute-Sec . Our reports requirement is that the user should be able to drill down from year - sec . Is this possible to define a hierarchy here containing attributes from both date and time dimensions?

saneel.b

Posts : 2
Join date : 2012-09-07

Back to top Go down

Drill down in cubes Empty Re: Drill down in cubes

Post  jryan Thu Oct 04, 2012 8:07 am

Its not possible to make a hierarchy in SSAS that spans 2 dimensions I'm afraid.

It is possible to make a dimension from multiple tables, if you wish, although that isn't best practice.

While it would work for you to make the one big hierarchy you describe, the approach I would advise is a dimension called Date (containing Year->Quarter->Month->Day) and then a seperate dimension called Time or Time of Day. This is a standard Kimabll practice as far as I'm aware, discussed in chapter 2 (pg 41) of the Data Warehouse Toolkit.

jryan

Posts : 33
Join date : 2010-09-27

Back to top Go down

Drill down in cubes Empty Re: Drill down in cubes

Post  Mike Honey Thu Oct 04, 2012 8:22 pm

I agree with jryans approach.

Most reporting tools will let you nest hierarchies from multiple dimensions within each other to achieve the business requirement you described. However performance varies greatly, depending on the MDX generated.
Mike Honey
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

http://www.mangasolutions.com

Back to top Go down

Drill down in cubes Empty Re: Drill down in cubes

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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