cancel
Showing results for 
Search instead for 
Did you mean: 

Row restriction

sourojit_pal
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member194529
Active Contributor

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

Answers (4)

Answers (4)

sourojit_pal
Participant

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

sourojit_pal
Participant

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

sourojit_pal
Participant

Hi Ivan,

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

Regards,

Sourojit

former_member194529
Active Contributor

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