on 2024 Jan 31 1:39 PM
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.
Not sure if this is possible in a star join, or there is another way.
Any assistance is always appreciated as always.
Regards,
Jerusha
Request clarification before answering.
Hello,
Yes that is exactly what I am trying to do.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.