1766134 - BI 4 : 'No values to display' error in WebI when trying to select value from cascading prompt

•  Cascading prompts are not  working correctly in “Rich Internet Application” mode.
• 'No values to display' error is coming up after selecting the 1st level of the cascading prompt in WebIntelligence

• SAP Business Objects BI 4
• WebIntelligence

1. Use the Emp & Dept tables from Oracle database to create your universe

2. Modify the Deptno object from the Emp class and add a where condition-
EMP.DEPTNO in @Prompt('Restriction prompt','A','Dept\Deptno',multi,free)

3. Create a universe level condition with the following syntax-
@Select(Emp\Ename) = @Prompt('1. Enter Name:','A','Emp\Ename',mono,free,,not_persistent,USER:201)
OR
@Select(Emp\Ename) = @Prompt('2. Enter Name:','A','Emp\Ename',mono,free,,not_persistent,USER:202)
OR
@Select(Emp\Ename) = @Prompt('3. Enter Name:','A','Emp\Ename',mono,free,,not_persistent,USER:203)

4. Create a new restriction EMP table using the @Where clause

5. Apply the restriction on any group or user. I tested it with Administrator User.

6. BI launchpad Rich Internet Application, create a new report using “Job” (from Emp class) and the universe level condition “Condition 1”

7. Refresh the report. This will show the cascading prompts

8. Provide/select a value for the Restriction prompt first otherwise (if not then it would not allow selecting any lower level prompts)

9. Select the “1. Enter name:” prompt without selecting any value for the “Restriction Prompt”

10. Now, select a value for “Restriction Prompt”. Say 20. It wuill now show the LOV’s for “1. Enter name:” prompt

11. However, it will not show any LOV’s for the “2. Enter name:” and “3. Enter name:” prompts.

->“No values to display”

This has been logged as a product defect : Bug # ADAPT01664575

This has been targeted to be fixed in patch 4.13

Workaround :

Use the HTML mode

KBA , BI-RA-WBI , Web Intelligence , Bug Filed