Variable with dynamic inlist

building reports webintelligence
1

I have a Column in Infoview like below…
Table values:
Col1
wwwwAAA
xxxxAAA
yyyyAAA
zzzzAAA
wwwwBBB
xxxxBBB
yyyyBBB
zzzzBBB

All the values ends with either AAA or BBB and these will be given as prompt. So if user selects ‘AAA’ in prompt I need to select all Col1 values where it ends with AAA.

Can anyone help me how to create variable for this.

BI.User (BOB member since 2007-05-22)

2

Use the “Matches Pattern” function in your prompt.

dessa :madagascar: (BOB member since 2004-01-29)

3

Dessa, Thanks for your reply.

But in prompt AAA will not be directly giving, i have description for AAA and BBB in different LOVs. Say if AAA description wll “All Accounts”. So in variable I am trying to do the below logic.

=[Col1] where ([Col1] inlist(concatenation(substr([Col1];1;4);if(userresponse(“Select Values”)=“All Accounts”;“AAA”;“BBB”))))

Above the code is not correct, I am just trying to explain the requiremnet.

Thanks

BI.User (BOB member since 2007-05-22)

4

Is your requirement to find all values with “AAA” or is it to place an “All Values” option in the prompt?

The first scenario should work with Matches Pattern, the second scenario is covered by a stick topic in the Universe forum.

Or do you want to change the LoV to sat “AAA” “BBB” etc?

dessa :madagascar: (BOB member since 2004-01-29)