Skip to Content

Hierarchy - Individual nodes with multiple parent

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded