Skip to Content

Row restriction

HI Experts,

We have a requirement where the restriction on 10K rows data fetch has to be removed. Can you please suggest how can this be done?

We have set the Global Parameter to 100000 however, we cannot find data fetch happening above 10K rows.

Regards,

Sourojit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Feb 21, 2017 at 01:16 PM

    Hi Sourojit,

    You can define the MAX_RESULT_ROW_SIZE global parameter with a value > 10.000 then. But please note that this can cause some performance issues, in case a template is not much filtered and will load several rows.

    Regards,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 05:05 PM

    Hi Sourojit,

    Just to confirm, is the Global Paramter MAX_RESULT_ROW_SIZE the one you already changed to more than 10.000 and is still not able to see more than 10.000 rows result on Excel? If this is the case, I would check if the MAX_DIM_MEMBERS parameter is not influencing on the results as well.

    Best regards,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 11:33 PM

    Hi Ivan,

    Could you please elaborate on what I have to check in this Paramater "MAX_DIM_MEMBERS"?

    Regards,

    Sourojit

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2017 at 12:54 AM

    Hi Ivan,

    We have MAX_DIM_MEMBERS defined as 100,000. However, MAX_RESULT_ROW_SIZE is not defined.

    Objective is to fetch more than 10k rows in both planning views and MDT Workbook.

    Regards,

    Sourojit

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2017 at 02:10 PM

    Thanks Ivan, I will definitely try that and update this post further on observing the result

    Add comment
    10|10000 characters needed characters exceeded