Symptom
In BI 4.0 "Unable to get the first page of the current report. Please check the validity of your report or contact your administrator (ERR WIJ 20003)" when adding an object from query 2 when you have merged query 1 and query 2 in a Webi report based on BW
Environment
- BI 4.0 patch 6
- Windows
Reproducing the Issue
- In IDT create two BICS Connections to two different SAP Bex queries query 1 and query 2 and publish them to the CMS
- Create a Webi report based on query 1 with objects: hierarchy object 1 , hierarchy object 2 (choose some members for this object) , dimension object 3 , key figure 1 , key figure 2
- Add the second connection to query 2 as a second query to the report
- Select the same fields for the dimensions and a different key figure key figure 3
- Run the report
- Merge the objects of the two queries (the ones under the hierarchy objects not the Hierarchy objects as it is not possible)
- Have in the report objects : object 1 (from query 1) , object 2 (from query 1) and key figure 1 (from query 1)
- Add the key figure from query 2 key figure 3 -> error raised "Unable to get the first page of the current report. Please check the validity of your report or contact your administrator (ERR WIJ 20003)"
Resolution
This issue has been addressed by patch 7
Keywords
webintellligence, merge, merging , KBA , BI-RA-WBI , Web Intelligence , Problem
Product
SAP BusinessObjects Xcelsius Enterprise 2008