#Overflow error

[former_member402770]

Hi experts

I have an webi report (SAP BO 4.1 SP3) containing two columns year and average age of account.

Year               average age of acct

2010              242

2011              147

2012              #Overflow

2013              #Overflow

2014              385

2015              375

The issue is #Overflow  for 2012 and 2013 year. Investigated in SAP Bw BEX ANALYSER there is an average exist for both year. I am not having any filters or bex prompt though. I am in need to display the record for average account age for 2013 and 2014.

Appreciate your help

Regards

Dinya

[amitrathi239 · Accepted solution]

check this sap note.

2107453 - Key Figures that result from a division by zero on OLAP, display the "#OVERFLOW" error in the corresponding cells.

Reproducing the Issue

1. Create a Web Intelligence document based on a Bex Query.
3. Among the objects of the query, select a key figure that result from a division where the denominator object presents some zero or empty values.
5. Run the query and observe that some cells display "#OVERFLOW" error as a result.

Cause

• This is a by design behavior.
• The "#OVERFLOW" error is shown as the key figures are returning "1.#INF".
• In previous releases, the "1.#INF" error was shown as blank in WebI. However, because of a change done with ADAPT01695268, the "#OVERFLOW" error is appearing.

Resolution

Workaround:

Use the IsError() function to handle this error and show blank as follow : =If IsError([Key_Figure]) then "" else [Key_Figure]

[former_member402770 · Accepted solution]

Hi Amit

  If I use iserror formula then I am getting the below result

Year        average age of acct

2010       242

2011       147

2012      

2013       

2014        385

2015        375

Because of one or two cells having #inf for 2012 and 2013 we are having the average resulting to null which shouldn't ...iam trying to get the below expected result for 2012 and 2013 omitting #.inf for few cells..average age is an direct key figure from bex.

2012      246

2013       643

Appreciate your help

Regards

Dinya

[amitrathi239 · Accepted solution]

have you tried to bring base objects in webi and do the average calculation at webi level..

[former_member402770 · Accepted solution]

No Amit as average age measure is available only as a direct key figure from bex. How can I proceed please advise.

Regards

Dinya

[amitrathi239 · Accepted solution]

if you know the objects on which average is calculated in the KF then you can try to bring those objects in the webi query and try.Edit your Average KF in BEx query designer and see which objects are used in the calculation.Add those in the BEx query and do the calculation at webi level.

if this is direct calculation then check with your BW team how this is calculated and what is the possibilities to add direct objects in the BEx query and do the calculation at BO level.