Skip to Content
avatar image
Former Member

Webi report Cascading Prompts in LOV’s with multiple repeated data with semicolon

In Webi report Cascading Prompts in LOV’s with multiple repeated data with semicolon
City is column name, having multiple repeated LOV’s with semicolon for different Mem ID’s
In webi report prompt i need to show the distinct values of city alone also if i select one city repeated for same city with different Member ID data has to come in report

Ex:

MemID City
~~~~~~~~~~~~~
Mem56 Texas
Mem57 SanAntonio; Texas
Mem58 Dallas;Texas;SanAntonio
Mem59 Dallas;SanAntonio
Mem60 Austin;Texas
Mem61 Austin;Colorado
Mem62 Florida;Austin;Texas

Expected Output:
~~~~~~~~~~~~~~~~~~~~~
When i run the report user have to get the city prompt inlist as below

Texas
SanAntonio
Dallas
Austin
Colorado
Florida

If user selects the Texas it is repeated in 5-times and Also user gets Mem56, Mem57, Mem58, Mem60 and Mem62 ID’s data into the report.

Please give me any solutions.
Thanks,
Gopinath Thangaraj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 12, 2017 at 04:37 PM

    Hi Gopi,

    Getting unique LOVs is going to be tough!! I've an idea for the second part of your question, as you said if Texas is selected, all the 5 rows should be included in report.

    Create a filter in the Universe as below, the idea is a use Like operator, and Texas would be concatenated with the wildcard character % (as prefix & suffix). Makes sense?

    TableName.City LIKE ('%'+@Prompt('Enter City','A','Class/City','Mono',persistent)+'%')

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded