Skip to Content

What is the limit for rows returned by a Bex query Design Studio with BW on HANA?

Hello DS pros,

Just wondering if there is maximum limit to the number of rows that can be returned to Design Studio with a Bex query?

I'm running DS 1.6 sp4 with a BW on HANA backend.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 08, 2017 at 08:56 PM

    Bex queryAccess in Design Studio:

    @ Prompts Level –

    Maximum number of members your number , default: 100 Specifies the maximum number of members displayed in the value help for prompts.

    If the number of members is greater than the value for this property, no values are displayed. Instead, the application user has to limit the number by searching for the text or key of one or more values.

    @ Data Display level - Safety belt is used to restrict large result-set of data retrieval from SAP BW using BICS connections.

    Universe Access in Design Studio:

  • Maximum Result Set
  • The result set has a fixed limit of 20000 rows or 200000 data cells. If either limit is exceeded, no data is displayed

Add comment
10|10000 characters needed characters exceeded