Post reply

line item and invoice design

  • May 10, 2009 at 2:19 pm

    #204768

    I am looking for advices of designing fact tables. I have a lowest line item level fact table, such as sku number, invoice_ price, quantity, etc. But, other things like tax, shipping are applied to the invoice level. Will it be better to put tax and shipping info in the lowest line item fact table and let application or users to aggregate it, or have another invoice level fact table, or some other better ways? Please help. Thanks.

  • July 1, 2009 at 7:29 pm

    #1018850

    At the lowest level you should include those only if you can apportion them somehow, if not it might make sense to make them their own fact, the fact table should be a VERY flat table.

    CEWII

  • July 2, 2009 at 7:26 am

    #1019129

    Thanks for your advice. My fact table includes all invoice level info, and don't see big performance impact so far.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply