cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy - Individual nodes with multiple parent

0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

JohnL
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.