SAP Knowledge Base Article - Preview

1626496 - BI40 - Webi reports show incorrect results when rounding decimal values based on OLAP data

Symptom

  • When an MSAS 08 based OLAP query is run, WebIntelligence or WebI  (Interactive Analysis) reports seems to show incorrect or inconsistent results when rounding numeric values over 2 decimal places.
  • However on Information design tool (IDT), upon running a query, the values are presented as the original data is
  • When queried against a Relational datasource (like SQL Server 08) with similar values, the values in WebI show up as expected with proper rounding
  • Eg: Original numeric field values : (also as seen in IDT)
    0.0697979797979121
    0.0759360179797979
    0.091507779797912100
    0.110448234979791000
  • Eg: Above values as seen in WebI report
    0
    0
    0
    0.09
    0.11


Read more...

Environment

BI40 sp02 patch 2.3
Win 2008 64-bit
MSAS 2008

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

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.