Skip to Content

Hierarchy - Individual nodes with multiple parent

Apr 26 at 03:24 PM


avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

John Leggio
May 01 at 03:19 PM

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.

10 |10000 characters needed characters left characters exceeded