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

Modelling Problem of Data Marts

2 posters

Go down

Modelling Problem of Data Marts Empty Modelling Problem of Data Marts

Post  abgoosht Mon Apr 02, 2012 10:36 am

Hi all,
I want to know about how modelling best data marts. For a better understanding the following schema of the data marts:

Fact_table_Order(Order_ID,
Article_ID,
Season_ID,Assortment_ID,
Fact_1
...
Fact_n)

Fact_table_Invoice(Articel_ID,
Invoice_Num,
Invoice_position,
Price
etc.
)

The requirement is to be also able to analyze, for example the fact "price" from the fact table invoice, through a specific season (from the fact_table_Order).
My Question is: How modelling this scenario best? Is is better to add a "Seaon_ID" column to the Fact_table_Invoice and connect the fact table also to the dimension Season or is it better to defer this requirement to the Reporting layer by joining the two fact tables (Data Marts) later and allow to use the season_ID of the fact table Order?

Any advice is welcome.
Thanks and best regards,
Abgoosht

abgoosht

Posts : 5
Join date : 2012-01-24

Back to top Go down

Modelling Problem of Data Marts Empty Re: Modelling Problem of Data Marts

Post  ngalemmo Mon Apr 02, 2012 2:28 pm

Why isn't price on the order fact? Also, the invoice fact usually carries a reference back to the order and line being invoiced.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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