1. to put the gist of the problem, i am trying to make an expense analysis report that compares my actual with its budget.
2. actual is coming from 1 fact table e.g. fact_general_ledger (grain = voucher number) and budget is coming from another fact table (grain = account [much higher than voucher number])
3. i have to calculate the variance (actual minus budget) at an account grain and make a percentage measure. hence i will get data like
View Complete Post