Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Database structure advice

Hi,   I have a database with 3 tables: Actuals (Volumes) Actuals (Money) Budget (Volumes)   Each of those tables has other tables linking into them (branch/region/area mappings, fiscal period ...
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi Anonymous,

     

    You need to have some master/dim tables like products, time cause your 3 tables are transaction tables, so you could choose new table and values() or distinct() function to achieve this.  And you could refer topic Budget Patterns of Marco Russo.

     

    (Sales and Budget tables in topic are your transaction tables like Actuals, Budgets)

  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi Anonymous,

     

    yes, it's same situation, there is no different

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi Anonymous,

 

You need to have some master/dim tables like products, time cause your 3 tables are transaction tables, so you could choose new table and values() or distinct() function to achieve this.  And you could refer topic Budget Patterns of Marco Russo.

 

(Sales and Budget tables in topic are your transaction tables like Actuals, Budgets)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi tringuyenminh92,

     

    Thanks - the budget files aren't split by product - the budget files are just split by branch/fiscal period/GL account. Does that make a difference?

     

    CM

    • tringuyenminh92's avatar
      tringuyenminh92
      Memorable Member
      9 years ago

      Hi Anonymous,

       

      yes, it's same situation, there is no different

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi Anonymous,

      Just as tringuyenminh92 posted, filter your resource table after some operation. You can use the transaction relationship between two tables, and construct them.

      Best Regards,
      angelia