SAP Knowledge Base Article - Preview

1491490 - Web Intelligence report displays incorrect results after migration from BOXI R2 to BOXI 3.1.

Symptom

  • A Web Intelligence report from BusinessObjects XI Release 2 gives incorrect results in BusinessObjects XI 3.1 after migration.
  • No changes have made in report.
  • Following formula gives correct results in a crosstab in BusinessObjects XI Release 2.
  • In Web Intelligence XI 3.1, the crosstab appears empty.
    =(Sum([Count]) Where ([All].[Status Desc]="APPROVED") +Sum([Count]) Where ([All].[Status Desc]="SUBMITTED"))/Sum..([Count])*100
  • Even if changing the formula structure to use 'If Then Else' instead of WHERE clause, this fails to return expected values and shows MULTIVALUE error.


Read more...

Environment

BusinessObjects Enterprise XI 3.1 Service Pack 3

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

Webi report, incorrect results, missing values. , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.