Skip to main content
M
Mikki
October 17, 2024
Solved

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

  • October 17, 2024
  • 1 reply
  • 0 views

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

Best answer by rhankey

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.

1 reply

R
rhankey
October 18, 2024

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.

M
MikkiAuthor
October 18, 2024

Thanks.

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

R
rhankeyAnswer
October 18, 2024

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.

Terms & ConditionsAccessibility statement