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

2 fact at different granuality demanding different level of a dimension hierarchy.

Go down

2 fact at different granuality demanding different level of a dimension hierarchy. Empty 2 fact at different granuality demanding different level of a dimension hierarchy.

Post  dattatraynale Wed Feb 16, 2011 9:50 pm

Hi,

Here is what i am trying to design.
There is a transaction level fact table say Fact1.. One of the dimensions for this fact table is Dim1, which has hierarchy as L1>L1>R1.. leaf to root.
The Leaf node (L1) of the dimension is Foreign key in the Fact1.

There is another dimension Fact2. this is at higher granuality. This needs to refer to the Root node of dim1. What is the better way to design this?

Option1 : Add the dimension key and value for R1 level directly in the fact table?
Option 2: Add a new dimension (Dime-2) that stores just the Root nodes (R1) of the dimension Dim1. and then point the fact to Dimension Dim-2?
Option 3: Any other solution?

dattatraynale

Posts : 3
Join date : 2011-02-16

Back to top Go down

Back to top

- Similar topics

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