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

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