cancel
Showing results for 
Search instead for 
Did you mean: 

How to join multiple calculation views to a calculation dimension

JerushaLala
Participant
0 Kudos
387

Hi All
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. 

jerusha7_0-1706707666386.png

Not sure if this is possible in a star join, or there is another way. 
Any assistance is always appreciated as always.

Regards,
Jerusha

Accepted Solutions (0)

Answers (1)

Answers (1)

JerushaLala
Participant
0 Kudos

Hello,
Yes that is exactly what I am trying to do. 
Thank you