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