Post reply

Fact Table Design

  • June 28, 2021 at 3:02 pm

    #3901239

    What is the consensus on storing individual components of a measure in the fact table versus just the calculated measure?  For example, in the attached image, should the sales amount, which is the product of sales price and sales quantity, be stored or just computed in whatever BI tool is used to surface the data warehouse?  Conversely, should the individual components be stored or just the computed value?

    Thanks, in advance, for your feedback...Chris

     

     

    • This topic was modified 3 years, 4 months ago by  CGSJohnson.

    Attachments:
    You must be logged in to view attached files.

  • June 28, 2021 at 3:12 pm

    #3901247

    Yes, I would store it in the fact table as well. The general premise is to make reporting as easy as possible, and if you can persist the Sales Amount to reduce the amount of work required for reporting, then it's a good idea to do so.

  • June 28, 2021 at 3:33 pm

    #3901261

    Thanks for the response, Martin.

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

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