Global Parameter issue !!

[anamika_mudgal]

Hello Everyone,

I am trying to view the records upto 13k . I have set the parameter MAX_RESULT_ROW_SIZE and MAX_DIM_MEMBERS , set the values up to 100,000 but I am not able to see the max view in excel.

Is there any other parameter for Plan_view to see the max views?

Regards,

Ana

[former_member194529 · Accepted solution]

HI Ana,

How many results are being displayed? 1000 ?

Both parameters (MAX_RESULT_ROW_SIZE and MAX_DIM_MEMBERS) should work with 100.000

Regards,

Ivan

[anamika_mudgal]

Hello Ivan,

Thanks for the reply.

The parameter you have proposed is for analytics. Does it work for planning view ?

Regards,

Ana

[former_member194529]

HI Ana,

This two parameters should do the trigger..in case you are still unable to see all the results, please check if below parameters are not interfering in the results:

max_import_rows

max_records

max_attr_values

Best regards,

Ivan

[ImtiazKaredia]

Check SAP Note

2108186 - S&OP / IBP Add-In for Microsoft Excel: Recommended Sizes for Planning Views

[anamika_mudgal]

I am looking .. Thanks