I am creating a QV model which interrogates our General Ledger.
I have successfully brought in the actual transactions from summary and detail GL tables.
I am having conceptual problems bringing in the budget. It is in a separate table and clearly at a different level, i.e. at cost centre / subjective code level, whereas the actual is at transaction level. What is the best way to link these two tables in conceptual terms?
As it stands I have 2 tables (act, bud) which are synthetically linked due to the need to link both GL code and the period.
Concatenate the budget table to transactions. This is the best solution in most cases. Easy to connect to same calendar or other dimension tables, easy to handle changes (like additional number of linked levels).