Forum Discussion
Solved
How to get a full outer join with relationship?
I have two tables Budget and Actual Budget: Account Year Month Value 1 2021 1 100 2 2021 1 200 3 2021 1 300 Actual: Account Year Month Value 1 2021 1 100 ...
You need to add 2 dimension tables: Dates and Accounts as shown in the screenshot. You have to add a date column too to the Actuals and Budgets table so that you can relate them to the Dates dimension table.
Then you can display the data in a matrix using the Account column from the Accounts table and the Year column of the Dates table. The result will be as such:
Thanks a lot. I see I need to go for full star modelling then (in my non-minimal version).