Integrating new fact table which has one to many relationship with the main fact table in existing star schema

View previous topic View next topic Go down

Integrating new fact table which has one to many relationship with the main fact table in existing star schema

Post  shankarmetla on Thu Aug 15, 2013 2:14 pm

We have a data warehouse with Revenue fact table having Freight Bill Number as the business key (granularity) along with 10+ dimensions. One Freight bill can have one or more commodity line items (commodity description and commodity weight are the main elements). Freight Bill to Commodities is one to many relationship. If the granularity level is same (that is one to one), we could have added the commodity description and weight in the Freight Bill fact table itself. Business users wants to be able to run analysis on commodiy description and calculations on commodity weights.

This Freight Bill Commodity table can be a new fact table with Freight Bill Number and Commodity description as the granularity. All dimensions are common between these two fact tables because they relate to the common key Freight Bill Number. What is the right approach or design (simpler to implement) to implement this one to many relationship between two fact tables. We have OBIEE on top of SQL Server data warehouse.

shankarmetla

Posts : 1
Join date : 2013-08-15

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