conformed dimension for two fact tables which are at different grain

View previous topic View next topic Go down

conformed dimension for two fact tables which are at different grain

Post  keka on Tue Sep 03, 2013 5:00 am

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

keka

Posts : 5
Join date : 2013-08-29

View user profile

Back to top Go down

Re: conformed dimension for two fact tables which are at different grain

Post  BoxesAndLines on Tue Sep 03, 2013 8:53 am

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

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