Hi!

I am trying to create a relationship/comparison between budgeted and actual amounts in Excel/Power Pivot with Odata from Budget (Page 120 G/L Budget Entries) and General ledger (Page 20 General Ledger Entries) for G/L Account No, Global dimension 1 and Date. However, when importing the above pages in Power Pivot I don't know how to create the relationship for Budget vs Actual for a specific account no, global dimension and date, as in the picture below - General Ledger and Budget appear as separate "sources" when i'm creating the Pivot Table and thus they cannot be compared

I have also done an import of page DimensionSetEntries and Chart of Accounts. Do any of you know how I can create a relationship and compare Actual Amount with Budgeted amount from the above Odata-pages in PowerPivot?