Question: Can you have dynamic row member filters between two columns?

[Ginger_Main]

Hello all,

This one is a bit of a doozy, so bear with me. In this specific instance of an application, we have multiple cubes that share identical hierarchies, except one cube uses the Entity dimension, and one uses the UD2 dimension. Ex. below:

Cube 1 = E#10001

Cube 2 = U2#10001

Our goal is to have a cube view that compares the actuals from Cube 1 to the Forecast of Cube 2. We have tried many ways to work around this, resulting in our most recent endeavor of using UD8 dynamic calculations to return a data cell value from a member script in Cube 2. Our issue is that while the UD8 shows the proper data, it does not allow end users to properly drill down from the data cell. It also does not allow a user to see the proper cell POV of the data being presented. Is there a better approach to this? Essentially, the goal is to have the row dynamically switch between the dimensions, UD2 and Entity, based on each column.

Other constraints to note are that this cube view needs to be created using a .base expansion in the row member filter. Thanks for any help!

Reference Below:

[JackLacava · Accepted solution]

---

@Ginger_Main wrote:

while the UD8 shows the proper data, it does not allow end users to properly drill down from the data cell

---

This is what the Formula for Calculation DrillDown is for, you can point the drilldown interface at an arbitrary set of intersections.

[Ginger_Main]

You are awesome thank you so much!