Skip to Content

"Size limit of result set exceeded" message in AO - Central Page

Hello everyone,

The reason for this post is to inform about our central page related to the "Size limit of result set exceeded" message in Analysis for Office.

This is a common situation and we hope to explain this scenario in Wiki page below in details:

Analysis for Office 2.x - Data Cells Limit and Memory Consumption

If you have questions related to this scenario or related to any information provided in the Wiki page above, please let me know here so we can clarify and update our Wiki if necessary.

Thank you and Best Regards,

Filipe Zeuch
SAP Product Support

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2016 at 06:54 AM

    Hi Filipe,

    could you clarify the sentence?

    "Please note that in HANA there is no such configuration option in backend"

    What is the real limit if a user sets the parameter to -1 at his client, reading data from BW on Hana ?

    Thanks, Martin

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Martin,

      This sentence means that when connected directly to HANA database (not BW on HANA), there is no parameter to set in backend (i.e. in HANA side) to change the result set limit. In this case AO will use the default of 500.000 data cells.

      If the user sets the parameter to "-1" in client side, when reading data from BW system AO will use the value defined in RSADMIN table as mentioned in the Wiki page.

      Let me know if any questions.

      Regards,

      Filipe

  • Posted on Jul 22, 2016 at 09:12 AM

    Hi Felipe,

    We have same error in our system. And we are going to try the steps you provided. But our issue is a liitle bit different. Because our query on Analysis doesn't have over 500.000 cells but it has 260 columns and 3 rows and it gives that error. The query works ok when the number of columns is about 100.

    I hope the solution will help us also, too.

    Thanks in advance,

    Fatih

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.