Numeric values rounded automatically in DeskI Report
Need your expertise in solving the following issue while doing a report using u2018Desktop Intelligenceu2019.
One of the report automatically converts (Round off) the Spend Amount (Numeric) to the nearest thousands.
Whereas the same query gives the full values in u2018Webiu2019.
I need to show the actual value without any rounding in the Desktop Intelligence report.
Actually I didnu2019t use any rounding function while designing the universe.
I have tried many methods like formatting inside the report, formatting the object in universeu2026but nothing works.
Iu2019ve also verified the actual table value and it consists the exact value without any rounding.
Hope you can advise me how to overcome this issue.
FYI, I am using BO XIr3 & the database is MS SQL 2008.
Thanks in advance.
Could you please also test the following solutions:
1.Change the object definition in the designer by adding Zero (0) or by multiplying with One (1).
2. Save the Universe and test the issue.
Use database-level syntax to convert the numeric database field to a string so that Deski Reports will interpret it as a string type, and display all of the characters.
For example, in Oracle, cast the number using to_char () and in Microsoft SQL Server use CAST() or STR() prior to adding the field to the report.