Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

conformed dimension for two fact tables which are at different grain

2 posters

Go down

conformed dimension for two fact tables which are at different grain Empty conformed dimension for two fact tables which are at different grain

Post  keka 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

Back to top Go down

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

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

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

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum