Im trying to do a consolidation account report. The data is from different schemas. I created 2 calculation view (cube), and a calculation view as a dimension with a listing of all the accounts.
I tried to created a "consolidated" calculation with a star join. But I can join the different calculation views(cubes) to the dimension calculation view.
This is essential how the final output should look. A sort of a appending each calculation to the end of the last column. There will always be the same number of rows.
Not sure if this is possible in a star join, or there is another way.
Any assistance is always appreciated as always.