Skip to Content
avatar image
Former Member

Global Parameter issue !!

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 10, 2017 at 12:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 04:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 04:24 PM

    Check SAP Note

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2017 at 04:58 PM

    Hello Ivan,

    Thanks for the reply.

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

    Regards,

    Ana

    Add comment
    10|10000 characters needed characters exceeded