SAP Knowledge Base Article - Preview

2011281 - What is the Web Intelligence Automatic Formula Rewrite Mechanism and how do I use it?

Symptom

  • Starting in BI 4.1 Support Pack 03, Developers have introduced a Automatic Formula Rewrite Mechanism to automatically correct formulas in Web Intelligence documents that are affected by known calculation engine changes
  • The Mechanism is a set of calculation rules that allow WebI to automatically rewrite report level formulas at view time to workaround known calculation engine changes:
    1. Running Calculations
    2. Where operator on measure
    3. Aggregation functions on individual objects inside a merged object
    4. Running calculation with reset in cross-tables (since 4.1 SP03 Patch 3)


Read more...

Environment

  • SAP Business Intelligence 4.1 SP03 or above (BI 4.x)
  • Web Intelligence (WebI)

Product

SAP BusinessObjects Business Intelligence platform 4.1

Keywords

WebI WebIntelligence Web Intelligence calc engine info information data formula variable change different unexpected results syntax rewrite re-write migration tool rules XML Formula_migration_rules.xml ExtractPlainDimFromWhereCond ResetOnSectionForCumulative UseMergeDimInAgg force enable true false , KBA , BI-RA-WBI , Web Intelligence , How To

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.