AFO Report rounding more than 14 digits

[former_member214778]

Hello AFO experts,

I built a AFO query on top of BW report. The BW report has 2 Measures. The datatype and length is 31,6.

However, when ever the values in those measure exceeds 14 didgits, the AFO report is rounding it.

For Example in BW I have some thing like this : 1.374.964.648.877.617.516.071,178405 .

In the AFO report I get something like this : 1,37496464887762000000000

I am not sure where lies the issue.

Regards,

Sai

[gregor_dieckmann]

Hi Mukesh,

this 'issue' exists with every basic data type used to represent numbers because of the fixed number of bits the data type has. Read the documentation about the data types used in Excel to get more information about the topic; you can also find good information on the internet about 'issues' that come with the DOUBLE data type.

Regards,

Gregor

[gregor_dieckmann]

Hi Mukesh,

this is no Analysis Office effect but comes from the number format Excel uses, i.e. is 'DOUBLE'. The limited precision of this format causes the effect you observe. Just use Excel without Analysis Office and enter big numbers or numbers with many decimals and check what happens ...

Regards,

Gregor

[former_member214778]

Hi Gregor,

Thanks for the answer. I concur. It is an excel issue. Do you think it has any fix or it is just a limitation from excel end.

Regards,

Mukesh

[former_member214778]

Hello All,

For the above issue we are in version : 2.7.400.87314