Can we make one entity Parent of 2 Child Entities

Adwait
Adwait Active Partner
Level 300: Expanding Board in Your Organization First Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board
in Platform

I have a Use Case where I must show totals as KPIs for a few Data Points.
The Data Points are at an intersection of 2 Entities - non-related to each other
If I use these cubes directly to show the KPI, the KPI Value changes by changing the page's selectors.
I was trying to bypass this by creating an entity that is the parent of both these entities and then storing data in a second KPI cube using a data flow.
Please let me know if someone has came across something similar

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    Answer ✓

    Hi @Adwait ,

    since the system is using the relationships to create aggregationpaths along the hierarchies, this is not possible.
    You could, however, use a mapping cube to "connect" those entities to each other. That cube would combine the source and target entity by a "1" on each desired match.

    Best,
    Helmut

Categories