Forum Discussion

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
5 hours ago

Cannot reference member expansion 1 from member expansion 2

Hi, I have a cube view with a straightforward requirement. Below is an example of my requirements using the Golfstream app. 

My rows are set as follows:

  • Member filter 1: U2#Clubs.ChildrenInclusive:name(UD2: |MFUD2Desc|)
  • Member filter 2: T#2011Q1.ChildrenInclusive:name(Time: |MFTime|, UD2: |MFUD2Desc|

The below screenshot shows what this returns. The issue is that I need to reference the member filter 1 member from member filter 2. When I use |MFUD2| from member filter 2, it reverts to my top UD2 member rather than reading my UD2 member from member filter 1. 

I need this to do a more complicated loop through members, and that loop must take the row's UD2 member into account. Any advice or workarounds? User-created parameters and |CVUD2| do not return what I need.

 

No RepliesBe the first to reply