2 fact at different granuality demanding different level of a dimension hierarchy.
Page 1 of 1
2 fact at different granuality demanding different level of a dimension hierarchy.
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?
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
Similar topics
» Joining Type II Dimension Hierarchy directly to Fact versus through a Dimension table
» Header Level Dimension for a Fact Table
» Allocating Header Level FACT table Dimensions FKs into Line Level Fact
» Two level keys from Hierarchhy Dimension into Fact table
» Transaction fact with different grain dimension hierarchy
» Header Level Dimension for a Fact Table
» Allocating Header Level FACT table Dimensions FKs into Line Level Fact
» Two level keys from Hierarchhy Dimension into Fact table
» Transaction fact with different grain dimension hierarchy
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum