Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Analysis Service

We have increased the limits in RSADMIN table as well.

Tags:
Former Member
Former Member replied

Hi Guys,

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

attached screenshot):

  -DAAD_BICS_DA_RESULT_SET_LIMIT_MAX=1000000

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!!.

2 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question