SAP Knowledge Base Article - Preview

1865796 - Web Intelligence formula displays incorrect result for reports migrated from BI 4.0 SP02 to SP05

Symptom

In BusinessObjects Business Intelligence BI4.0 SP2 a formula like

=Aggregationfunction( <expression> Where (conditionOn([Measure]) ForEach ([Dim]))) ( with [Dim] is not in the table where the formula is asked) was not always returning the correct result.  

 Ex: =Sum(1 ForEach ([Display ID]) Where (IsNull([Actual ROI])))

In BI 4.0 SP05 this formula displays always correct results.

If you have created a report with BI4.0 SP2 with this formula, this report may show different results (but correct) in BI4.0 SP05.


Read more...

Environment

  • BusinessObjects Business Intelligence BI4.0 SP2 patch 14
  • BusinessObjects Business Intelligence BI4.0 SP05

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

formula,foreach,where,null,migrate,webi,incorrect , KBA , BI-RA-WBI , Web Intelligence , Problem

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.