Skip to Content

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

Fixed - Result set is too large message in ADV. ANALYSIS OFFICE 1.0

Hi community.

Max cell per default - 500 000, but sometimes you business need more than 500K.

If you get this message in AAO, please do next step (information from sap support, thanks Carol from China):

On client PC set parameter in windows registry:

[HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\DataSource]

"ShowBicsSample"="True"

"ResultSetSizeLimit"="-1"

u201C-1u201D: limits from each server will control the data sources of this server>= 0: fixed limit for all data sources

NOT_EXIST: 500000 is default.

It is already available with SP7.

P.S.> Please keep in mind server memory consumption on heavy reportsu2026.

Dear moderators, please create dedicated branch for AAO.

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