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?