on 04-26-2018 4:24 PM
Hello Team,
This is regarding SAP Analytics cloud. I have a requirement like the one below.
F1 = A + B + C
F2 = A + D
F3 = B + D
Where A, B, C and D are the measures. I was able to create F1, F2 and F3 with no issues. Then I thought, if I can roll-up A, B, C to F1 using hierarchy, I will be able to drill down F1 and show A, B and C, which worked like a charm. However, for F2, since A is already a part of F1 (F1 as the parent), I can't repeat the same for F2 and F3. Is there any other way to get this achieved?
Hi Karthikeyan,
We only support 1 hierarchy in the account dimension at this point.
You could create a formula for F2 and F3 for now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.