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

SAP Knowledge Base Article - Public

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

Symptom

  •  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

Environment

  • SAP Business Objects BI 4
  • WebIntelligence

Reproducing the Issue

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

universe_structure.png

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)

deptno_object.PNG

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)

condition.PNG

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

restriction.PNG

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”

query.PNG

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

cascading_prompt.PNG

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”

no_values.PNG

 

Cause

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

Resolution

This has been targeted to be fixed in patch 4.13

Workaround :

Use the HTML mode

 

Keywords

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

Product

SAP BusinessObjects Xcelsius Enterprise 2008