locked
Budget vs. Actuals RRS feed

  • Question

  • If you have budget and actual fact tables, should you combine them and have a column that specifies whether it is actuals or budget? Or should you create two seperate tables? 
    Friday, January 20, 2017 5:51 PM

Answers

  • Hi Albo44,

    Whether combine budget and actual fact tables depends on your table structure and requirement. If they have same structure, you can combine them to one table, then add a column which specifies whether it is actual or budget. While the efficiency may be slow, you also can create separate tables.  

    Best Regards,
    Angelia


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, January 23, 2017 3:09 AM

All replies

  • Hello, 

    If granularity of the data is the same for both source fact tables then it makes no sense to combine them into one table. All your aggregations will work correctly over both tables. 

    N - 

    Friday, January 20, 2017 6:09 PM
  • Hi Albo44,

    Whether combine budget and actual fact tables depends on your table structure and requirement. If they have same structure, you can combine them to one table, then add a column which specifies whether it is actual or budget. While the efficiency may be slow, you also can create separate tables.  

    Best Regards,
    Angelia


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, January 23, 2017 3:09 AM