Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

WebI prompts rounding decimal values to 2 digits


                Has anyone ever experienced this?

               When using a dimension that is a decimal with 4 digit precision (could probably be 3 and more), when using that dimension in a prompt in the Query Panel, WebI is rounding that number to 2 digits.  This can be seen by viewing the Query Panel SQL script.  When using it simply as a constant, it does not get truncated.  The 4 decimals are really important as measures associated to these points are used thereafter to retrieve all the records within an interval based on that dimension.

                Ex:  Between 15.5555 and 16.5555 is not the same as between 15.56 and 16.56...

                The values are set as dimensions even if the values are decimals as they reflect coordinates.

Database field is set to Numeric with 4 precision.

Datafoundation layer is set to Numeric with 4 precision.

Business Layer is set to Numeric.

When displaying values at each step, values are correct.


Windows Server and Windows workstation

BI LaunchPad WebI HTML/Java

BI 4.1 SP3

UNX on Netezza database.

Not what you were looking for? View more on this topic or Ask a question