Forum Discussion

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
2 days 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.

 

Cube View
Parameters
Reports

1 Reply

  • Ruben_Moya's avatar
    Ruben_Moya
    New Contributor II
    7 hours ago

    Hello DRider,

    Maybe you can try to use an XFBR that generates all the member filters with the ":Name(XXX)" delimited by a "," that you need dynamically just using the member filter 1.

    Hope this helps!