Forum Discussion

Mikki's avatar
Mikki
New Contributor III
3 months ago

Member filter using Text field of UD that varies by Year and Scenario

Hi,

Is it possible to create member filter in QV using Text1 that varies by Year and Scenario. Is it dynamic enough to read T# and S# of POV and use them to get Text1? 

For example, I have few members with "AAA" in 2024 and "BBB" in 2025.  In other members, "BBB" is in2024, and "AAA" in 2025. I want to pull all UD2 members that have "BBB" in 2025.

If this doesn't work, other way is BR "CustomMemberList" I guess. Anyone has sample code that can create list by reading Text1 in 2025?

Thank you in advance,

Mikki

Excel Add In
  • rhankey's avatar
    rhankey
    3 months ago

    You will need to create a U8#[Dim]Text1 dynamically calculated member that uses the OS api to return the Text1 property for api.pov.[Dim].MemberId

    In the Cube View or Quick View you would surface the Text1 property using V#Annotation:U8#[Dim]Text1.  The POV for all dimension members of the cell is automatically passed through to the dynamically calculated member.

  • rhankey's avatar
    rhankey
    Contributor
    3 months ago

    Yes it does.  If you have Scenario and/or Time in the Rows or Columns, you may need to specify the Scenario and/or Time in the Row or Column in which you surface the Text1 property to get appropriate Text1 property.

    • Mikki's avatar
      Mikki
      New Contributor III
      3 months ago

      Thanks.

      are you able to give an example if it is possible in QV?

      • rhankey's avatar
        rhankey
        Contributor
        3 months ago

        You will need to create a U8#[Dim]Text1 dynamically calculated member that uses the OS api to return the Text1 property for api.pov.[Dim].MemberId

        In the Cube View or Quick View you would surface the Text1 property using V#Annotation:U8#[Dim]Text1.  The POV for all dimension members of the cell is automatically passed through to the dynamically calculated member.