Skip to Content
avatar image
Former Member

Cannot display all possible data

Hi,

Running a design studio 1.4 report ends up with

Error Massage - Result set too large (973420 cells); data retrieval restricted by configuration (maximum = 500000 cells)

Checking backend RSAMIN table

BICS_DA_RESULT_SET_LIMIT_DEF    4000000

BICS_DA_RESULT_SET_LIMIT_MAX    4000000

There should be enough room for all the data to be displayed. What exactly is preventing it from doing so?  Anybody?

Thank you in advance.

Best regards,

Zabrina

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 22, 2014 at 12:06 PM

    Zabrina - for the universe there are limits on data coming back per the Help

    But my guess is your data source is the BEx Query.  What is the business case / scenario to bring back so much data to your dashboard application?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Deepu Sasidharan

      Hi Deepu,

      Thank you. I have seen Karol's post. I am looking forward to knowing exactly where to check and how to change it so that I can send this information to the right team to perform those actions. Somehow, there must be somewhere that is restricting the data from coming.

      Hope for the best.

      Best regards,

      Zabrina

  • avatar image
    Former Member
    Dec 22, 2014 at 05:42 PM

    HI,

    I would like to know if the same or different restriction applies to both platform- or locally run application.

    Also when I test with little data to start with and then add some more data in the report, I am getting a series of  error messages which I am not sure if it is related to this or not:

    I appreciate if someone can help me to sort out the problems.

    Thank you so much in advance.

    Best regards,

    Zabrina


    Screenshot.png (65.0 kB)
    Screenshot1.png (87.4 kB)
    Screenshot2.png (69.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ingo Hilgefort

      Hi,

      Isolating the source would be the first step as Ingo stated, but for me, it's a SAP error. Note that 1.4 is not supported anymore and patch to 1.6, or at least 1.5, could fix them.

      Does you query has any special feature in it ? Like counters, exceptions, conditions, exception aggregations ...

      Look at sap notes with your error, it could help.

  • avatar image
    Former Member
    Mar 29, 2016 at 03:40 PM

    HI Zabrina,

    I found in RSRT to increase the capacity of ROWS is that suit your answer?


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 29, 2016 at 03:54 PM

    Hi Zabrina,

    Look in the CMC to the configuration on the APS server common service Multidimensional Analysis Service.

    The limit is set in the properties, and you can increase it.

    When you say "Local mode" with DS, are you still connected to the BIP ? If yes, I would say the same parameter applies, or it would be located in the preferences of DS.

    Basically, Rsadmin preferences are taken in account only if you connected directly to the BW server, and not though the BIP.


    Add comment
    10|10000 characters needed characters exceeded