combine order, invoice, and backlog detail in one fact table

View previous topic View next topic Go down

combine order, invoice, and backlog detail in one fact table

Post  soup on Tue Mar 05, 2013 11:55 am

I am thinking of combining the order, invoice, and backlog detail in one fact table. They all have the same dimensions and level of grain. The total of the invoices = orders+backlog.

I don't see any benefit in having 2 fact tables. One with invoice detail and one with order and backlog(open orders) detail.

Do you see anything wrong with this?

soup

Posts : 2
Join date : 2013-03-05

View user profile

Back to top Go down

Re: combine order, invoice, and backlog detail in one fact table

Post  ngalemmo on Tue Mar 05, 2013 1:24 pm

Yes. An order and an invoice are entirely different things. You may consider creating an aggregate of the two, but I would not replace the two facts with a single fact.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: combine order, invoice, and backlog detail in one fact table

Post  soup on Tue Mar 05, 2013 1:30 pm

Thanks!

soup

Posts : 2
Join date : 2013-03-05

View user profile

Back to top Go down

Re: combine order, invoice, and backlog detail in one fact table

Post  Sponsored content


Sponsored content


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