I have an Expenses table that has the following fields:
Year, Quarter, Framework, Topic, Subject and Expense Amount
A framework has different Topics, a Topic has different Subjects.
Then I have my budget table with the exact same fields except it has "Budget Amount" instead of Expense amount.
Now I've read to concatenate them but unfortunately concatenating them (at least in data manager) leaves the budget amount field empty with nulls. When I associate them as separate tables on the lowest level "Subject" the budget obviously appears on each row if I have that subject appearing 5 times the budget amount appears 5 times.
How can I approach this? I would like to compare expense vs budget on all 3 levels, for Framework, Topic and Subject without the data being aggregated. Something through a dimension link table? Is it granularity, cardinality?