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 me...
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

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.