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.