Not able to retrieve more than 500000 cells in Design Studio 1.5 on Bex query
We have a design studio report build on bex query. We are
getting the below error message in design studio.
We have increased the cells limit in both Analysis Service and also MDAS from the default 500000.
But still we are getting the above error.
The bex query runs fine in WAD and Bex analyzer.
We had this issue in 1.4 as well so we upgraded to 1.5 , but still this issue is there.
We have increased the limits in RSADMIN table as well.
We opened a case with SAP support and below is the solution for it.
This seems to be a issue with 1.5 , To make it work use the below workaround.
1. Open the CMC Server Properties page for your
APS (where you already
set the Maximum number of Cells).
2. In the edit field labelled "Command Line Parameters", immediately
after the string "-server", insert the following text (also see
3. Restart the affected APS
Note, as with the other setting, you would need to do this for each
APS within which Design Studio is running.
I tested it for my case (15 Lakh cells) and it works.
It will be addressed in 1.5 Sp1.
Thanks to all guys for their support!!.