conformed dimension for two fact tables which are at different grain
2 posters
Page 1 of 1
conformed dimension for two fact tables which are at different grain
Hi,
can anyone give me information on how to design a conformed dimension for two fact tables which are at different grains
I got a forecast fact table at
Month,Model,Engine,BodyType,Sales
and another order Fact Table
Month,Model,Engine,BodyType,EnginePower,......,Qty
I have to design a conformed dimension to use against the above two facts
Do I need to Build Master Conformed dimension and Derive new Dimension tables according to the grain of Fact Table ???????
Any help is much appreciated
Thanks
Keka
can anyone give me information on how to design a conformed dimension for two fact tables which are at different grains
I got a forecast fact table at
Month,Model,Engine,BodyType,Sales
and another order Fact Table
Month,Model,Engine,BodyType,EnginePower,......,Qty
I have to design a conformed dimension to use against the above two facts
Do I need to Build Master Conformed dimension and Derive new Dimension tables according to the grain of Fact Table ???????
Any help is much appreciated
Thanks
Keka
keka- Posts : 5
Join date : 2013-08-29
Re: conformed dimension for two fact tables which are at different grain
You're making this more complex than it is. Dimensions are independent of facts. You model them, and then relate them to the fact tables. The grain of the fact table is irrelevant.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» calendar grain on both dimension and fact tables
» Differing grain dimension tables with the same transactional fact
» Linking two Fact tables with different grain through a hierarchy dimension
» Geography Dimension with diffirent grain in fact tables
» Using a dimension in multiple fact tables with different grain and support SCD
» Differing grain dimension tables with the same transactional fact
» Linking two Fact tables with different grain through a hierarchy dimension
» Geography Dimension with diffirent grain in fact tables
» Using a dimension in multiple fact tables with different grain and support SCD
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum