1453183 - Blank Cells display in Web Intelligence report using BEx Query with Unassigned Hierarchy selected when filtering on detail object

SAP Knowledge Base Article - Public

1453183 - Blank Cells display in Web Intelligence report using BEx Query with Unassigned Hierarchy selected when filtering on detail object

Symptom

  • You see blank cells in a Web Intelligence report when you have filterd on a detail object
  • When you remove the filter the blank cells do not display
  • The key figure displayed to the right of the blank cells is a Sum of the unfiltered detail objects

Environment

  • Business Objects Enterprise XI 3.1
  • SAP BW 7

Reproducing the Issue

  1. Create a Web Intelligence report using a Universe based on a BEx query with hierarchy nodes
  2. In the Result Objects Add L00 Detail, L01 Detail and some key figures
  3. Refresh the report - It displays correctly
  4. Add L01 Detail object to the filter and choose only one of the values
  5. Refresh the report - It displays the filtered hierarchy node and some blank cells with the SUM of unfiltered hierarchy nodes next to the blank cells

Cause

Adding L00 detail to the Result objects is requesting "ALL objects" the report will display the filtered object with the key figures and also display the ALL detail and Sum the key figure.

Resolution

Remove the L00 Detail from the Result objects

Keywords

webi , KBA , BI-RA-WBI , Web Intelligence , Problem

Product

Crystal Reports 2008 V1