Skip to Content
Apr 26, 2018 at 03:24 PM

Hierarchy - Individual nodes with multiple parent

420 Views Last edit Apr 26, 2018 at 03:25 PM 2 rev

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?