Skip to Content

Analysis for Office: Hierarchy expansion and collapse

Hi Friends,

I have two questions related to hierarchy in Analysis for office (AO). Our version AO 2.6 (SP3)

1) Expanding the hierarchy and collapsing is taking a lot of time.


We are able to expand the vertical hierarchy to the lowest level, but we try to expand the horizontal hierarchy the system is throwing an error “Size limit for result exceeded”. We are getting this issue sometimes when we try to expand a single node also. Then we need to start again.
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 22, 2019 at 08:21 AM

    1) It seems that AO refreshes the query, every time you expand the hierarchy node, so for more complex queries it may take some time. Maybe try to optimize your query and limit the result set if possible.

    2) This error is pretty self-explanatory - it means that you are trying to display more cells than the default limit of AO which is 500 000 data cells You can see details here . There is a statement:

    In Analysis for Office, there is a default limit of 500.000 data cells for the result set. This limit exists because of a memory limitation in .NET framework explained in section #4.When the report retrieves too much data from the backend and ends up reaching the limit of data cells, the message "Size limit of result set exceeded" will be shown in AO instead of the expected data.

    It's possible to change the default result size, however it is not recommended. If you want to exceed the limit,

    1. Go to Analysis -> Customize Analysis -> Technical Configuration

    2. In the search box type "Size" and you will see ResultSizeLimit property which you can change:

    conf.png (22.1 kB)
    size.png (11.3 kB)
    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.