avatar image
Former Member

Not able to retrieve more than 500000 cells in Design Studio 1.6 on HANA view (via BI Platform)

Hello,

In the Design Studio Client tool, I have logged into BI platform and then connected the datasource to OLAP connection on HANA calc view. When I preview the default fields with more than 2 measures, I get the message "Result is too large; data retrieval by configuration (maximum = 500000 cells).

Based on the DS admin guide, in the Analysis Application Service Configuration, I have increased the number of cells from 500000 to 800000, but yet I get the same message.

Appreciate any advise.

Add comment
10|10000 characters needed characters exceeded

  • First, can you pull that much data back with a direct connection to HANA? Does it work then? Next question - what is the business reason to bring back so much data? Remember before SAP recommended to only bring back 500 rows for a dashboard application.

  • Get RSS Feed

5 Answers

  • Feb 19, 2017 at 12:14 PM

    Hi Tammy,

    I have another question wrt to volume of data and native Hana. Assumption.: source contains a million record and expected volume to be dumped in target is ..lets say 50k. What is the volume limit of data a View can retrive from a table?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 19, 2017 at 02:15 PM

    Hi Tammy,

    Currently in production we are using Web Application Designer (WAD) + BEx query for a line item detail report. So now we are testing the same item details in Design Studio because design studio is supposed to replace WAD.

    Other than direct OLAP connection on HANA, what are the other options to connected via Design Studio?

    Thanks

    Ann

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 20, 2017 at 06:00 AM

    Hi Tammy, I setup the HTTP connection, but when I try to login directly to HANA, I get the below error message. Any help will be great!

    By using HANA HTTP connection, will I be able to avoid the 500000 cell limitation?

    Thank you

    Ann

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ann - you may want to ask your HANA administrator for help with the HTTP connection

      I don't know if you can bypass the cell limitation, but going direct is one less bottleneck (in my view) to send data through - direct would appear to be faster to me.

  • avatar image
    Former Member
    Feb 21, 2017 at 01:44 PM

    Does anybody know how we can bypass the 500000 cell limitation?

    Thank you!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2017 at 04:13 PM

    Hi Tammy, Cell limitation still applies via HTTP connection.

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content