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

Measures based on different hierarchy levels

2 posters

Go down

Measures based on different hierarchy levels Empty Measures based on different hierarchy levels

Post  IIT'ian Mon Aug 06, 2012 5:49 pm

Below is our current dimension hierarchy -

Location Hierarchy : CHAIN -> Operation -> Market -> District -> Community -> Store..
I have 8 fact tables based on different categories Product, Employee, Rx etc.; so each category has it's own metrics. But, the metrics differ based on the level in the location hierarchy.

Product fact table can have 4 metrics at chain level and 2 metrics at market level.
Similarly the other fact tables.

How should I model my fact and dimension tables for addressing the above scenario. Please advice.




IIT'ian

Posts : 2
Join date : 2012-08-06

Back to top Go down

Measures based on different hierarchy levels Empty Re: Measures based on different hierarchy levels

Post  BoxesAndLines Tue Aug 07, 2012 8:43 am

You need to build separate fact tables at the varying grains. If the metrics are not the same grain, you can't put them in the same fact table.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Back to top

- Similar topics

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