BO Universe Design Layer (UDT) Prompt

199 Views Last edit May 14, 2020 at 12:55 PM 2 rev

Hi All,

I have a requirement on division (character) filed to have a prompt select * for all the divisions or individual values.

Here are the steps i followed:

1. Created a prompt with below info.

@Select(class\Division) IN @Prompt('1.Enter * for all Divisions','A','class\Division,Multi,free) OR

('*' IN @Prompt('1.Enter * for all Divisions:','A',class\Division',Multi,free))

2. I created a LOV list to add *

Tools --> Edit Lov list --> Division --> Edit values --> SQL --> i have added UNION '*' from DUAL Order by 1

Selected the checkbox to generate SQL before execution

3. Exported the universe after save

Issue:

I am getting the Division prompt 2 times when i run the report for execution (these Universe prompts are not OPTIONAL).

Is there any issue with my approach? Or i missed any steps?

Please let me know.

Thanks

Vinay