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

View previous topic View next topic Go down

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

Post  dattatraynale on 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

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