Custom Filter in Universe on top of BEX Query is not working in BO Explorer?

[Former Member]

Hi,

I have created Condition(Filter) for an Dimension Object "Submitted by Group Hierarchy" in Universe designer tool on top of SAP BEx Query and then exported the universe to Repository.

<FILTER KEY="@Select(Submitted By Group Hierarchy\L01 Submitted By Group Hierarchy).[TECH_NAME]"><CONDITION OPERATORCONDITION="InList"><CONSTANT CAPTION="@Prompt('Submitted By Group ','A',' Submitted By Group Hierarchy\L01 Submitted By Group Hierarchy',multi,primary_key,,{‘Direct Sales’)"/></CONDITION></FILTER>

To test my custom filter , I have created WEBI report and its allowing input entry in my custom filter and output is also coming .

where as in Explorer, i am not able to enter input values for my custom filter as below.

Can anyone suggest me how to create custom filter in universe and use it in explorer.

Thanks in advance.

Regards,

Ramana.

[Former Member]

Hi Ramana,

Please try using 'mono' in place of multi in @prompt syntax and then test.

Regards,

Pranay Sharma

[Former Member]

Hi Raman,

Let me know if the issue is resolved and how?

Regards,

Pranay