Memory Error-Size Limit of Result Set Exceeded in Advanced Analysis

[Former Member]

Hello Team,

we are using AAO 2.0.

We are getting Memory error when running report HANA View in Analysis Office.

We followed below thread and made changes but it was not working. what i under stood the below thread related to BW not ECC system.

Do you have any idea?

Regards,

Subbu

[Former Member]

Hello,

Increase value of "Maximum Number of cells returned by a query" value and also increase "Maximum number of members returned when filtering" Value in Adaptive Processing Server Analysis. It is for If you are using SAP BO 4.1.

[Former Member]

Hello Dhaval,

thanks for the reply.

But my source HANA live ERP system not BW.

let me check with basis team and come back to u.

Regards,

Subbu

[Former Member]

Hello,

This change need to be done in SAP BO as Analysis for Office is part of SAP BO tool.

Regards,

Dave

[Former Member]

Hello All,

Thanks for the quick response.

i am checking with basis team.will get back you.

Regards,

Subbu

[Former Member]

Hi Dave,

thanks for the tip.

regards,

Roberto Lima

[Former Member]

I Need to clarify some confusion here:

The settings on the BI Platform affect only analysis for OLAP, but this thread is about analysis for office, so changing settings in the APS on the BI Platform won't help.

I Would go with Subhash suggestion and change the registry settings.

Best regards,

Victor

[Former Member]

Hello All,

Changing the settings on the BI platform will not effect.

@Victor:

I tried Subhash suggestion also and changed the registry settings.But no use.

Kindly help me.

Regards,

Subbu

[former_member110741]

Hi Subbarao,

in 1.4 you will use registry settings to for setting limit

Did you change the setting value in AO 2.0 settings(elow document)

Subhash

[Former Member]

Hello Subhash,

i am not clear  this point :i n 1.4 you will use registry settings to for setting limit.Do i need to change the settings in AAO 1.4.

Regards,

Subbu

[former_member110741]

Hi Amarnathaluri,

if you are using 1.4 - Then registry settings

if you are using 2.0 - follow the mentioned document and change accordingly your setting and try it

Subhash

[TammyPowlas]

Can you share the exact memory error message? Please use the camera icon to upload a screen shot of the error message

[Former Member]

Hello All,

first  i tried with AAO 1.4 only after that updated to AAO 2.0.

After executing report when i am trying to drill down the one object i am getting below message.

i am able drill down all the objects except one object.

Please find the below error message.

Regrds,

Subbu