on 02-20-2017 6:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Ivan, I will definitely try that and update this post further on observing the result
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ivan,
Could you please elaborate on what I have to check in this Paramater "MAX_DIM_MEMBERS"?
Regards,
Sourojit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.