Hi All,
We have a Web I report created on BEx Query data provider .
A.While Scheduling ,default prompt value for report is 0111 (for example) only ,but why the scheduling getting failed every time with below error.
Error :: BW System BWP: Result set too large (900783 cells); data retrieval restricted by configuration (maximum = 900000 cells)
B.Moreover report has a prompt with default value (for example -0111) and data generated in the report with fields for 0111 only.
If we run the report with 0111 or some few values ,report was generated but If we run the report with all the prompt values,we are getting below error.
BW System BWP: Result set too large (900783 cells); data retrieval restricted by configuration (maximum = 900000 cells)
"Is there any configuration problem with Adaptive job server and Web I Adaptive processing server ?"
Kindly provide the solution to overcome this issue.
Note : 1. We can't reduce the prompt values ( all values should be selected )to over come this issue.
2.Global parameters i.e., increasing the cell size in BEx Query properties should be restricted.
Thanks
Ram