SAP Knowledge Base Article - Preview

1554369 - Web Intelligence reports containing formulas with WHERE clauses evaluate to 0 (zero) after migration to XI 3 if the dimension in the WHERE clause is not included in the table

Symptom

  • Web Intelligence reports containing formulas with WHERE clauses evaluate to 0 (zero) after migration to XI 3 if the dimension in the WHERE clause is not included in the table
  • If the formula is used in a table where the dimension used in the WHERE clause is included in the table the formula evaluates correctly


Read more...

Environment

  • BusinessObjects Enterprise XI 3
  • Web Intelligence

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

WebI, WebIntelligence, Web Intelligence, WHERE, clause, 0, zero, incorrect, wrong, not correct, calculate, evaluate, display, upgrade, migrate, formula, variable, report level, report, document, level, null, ADAPT01498984, ADAPT1498984, ADAPT, 01498984, 1498984 , 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.