Filter LOV

[Former Member]

Can I provide the users with a LOV which can be filtered by other LOV's?

For example I provide a LOV wiht different products. This list should be filtered by an other LOV providing the years in which the products are available.

Regards, Adrian

[Former Member · Accepted solution]

Hi,

Yes we do

Creating Cascade list of values:

In Universe designer go to Tools > List of Values > Create Cascading List of Values

*Create prompt under prompt*

Like:

Case

when @Prompt('Enter partner view','C',{'Country Wise','Network Wise'},mono,,,)='Country Wise' then @Prompt('Enter partner Country','C','Partner_Country\Countryname',mono,,,)

when @Prompt('Enter partner view','C',{'Country Wise','Network Wise'},,,,)='Network Wise'

then @Prompt('Enter partner network','C','Partner_Network\Partner_Name',,,,)

end

All the best,

Praveen

[Former Member]

In Universe designer go to Tools > List of Values > Create Cascading List of Values.

You can define the cascading hierarchy of objects, e.g. Year > Product. Save and export the universe after the LOV changes are complete.