Skip to Content
avatar image
Former Member

Webi truncating and rounding up values

Dear Experts

We have a webi on a Bexx Query where data is populating fine on Webi the only issue is it is truncating decimal figures and rouding up values.

In bexx we have set as 2 decimal for that calulated keyfigure when we are executing Bexx in rsrt data is appaering fine but when i am checking on webi level it is trucating decimal values.

For eg.

In Bexx we are getting:

5.6

0.4

0.7

2405.6

In Webi it is turning out as:

6

0

1

2405

Our envieonment is SAP BI7.3 & BO4.0 Build 565

Please help.

Thanks,

Prateek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 13, 2012 at 03:31 PM

    Hi,

    Is this based on a MDX olap .unv Universe?   It sounds very much like the bXML 'flattening' problem we used to get in the MDXINTERFACE

    Also, What's your SP and Patch level ?   Most customers are on SP02 Patch2.17/18/19 or SP04


    Regards,
    H

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      PAM is for information on supported platform.

      In case you are looking for issues fixed with-in SP04

      you can try @ http://help.sap.com/bobip

      Look for What's New/Support Package and Feature Pack Known and Fixed Issues

      May be you may get something in this.

      Thanks,

      Vivek

  • Jun 27, 2012 at 04:33 PM

    hi prateek,

    Could you please check whether formatting number in webi is solving your issue (FormatNumber([Total Earnings];"#,##.##").

    If data from universe itself is truncated, then please check in universe or in BW backend. pls check the below link if useful.

    https://cw.sdn.sap.com/cw/servlet/JiveServlet/previewBody/147756-102-1-316890/How%20to%20troubleshoot%20BW%20issues%20in%20BO%20XI3%201%20and%20BI4%200.pdf

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Manesh

      Thanks for your comments ....however format number technique will work on webi report but in my case data already got trucated when i receive data at query level, i am not getting decimal places there....

      when i preview data on query panel level i surprised data already got trucated and rounded up.......

      also the note you have mentioned "1633215" in the pdf does not exist or under internal purpose only.........

      Can you please provide me some details related to this note ?Is this patch is already appliedon  BI 7.3 etc?

  • avatar image
    Former Member
    Jun 27, 2012 at 07:30 PM

    Hi,

    Right click on the cell where it is truncating...>>format number>> and select a number format wich has desired number of decimal places.

    Thanks,

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 13, 2012 at 04:34 PM

    At the Universe Level if you have access right click on the object and select object format. In the next window that pops up select number and set the desired format. You should be able to get correct result on the report.

    Hope this helps

    Add comment
    10|10000 characters needed characters exceeded