Setting Retrieval-Buffer Sizes

For databases for which you have Database Manager permissions, you can set the sizes of data retrieval buffers.

Essbase uses retrieval buffers to process and optimize retrievals from Spreadsheet Add-in and from report scripts and uses retrieval sort buffers to hold data to be sorted during retrievals. If a retrieval sort buffer is full, Essbase returns an error message.

To determine optimum buffer size, test a report script with different settings.

  To set retrieval-buffer size for databases:

  1. From Enterprise View or a custom view, select a database.

  2. Right-click, and select Edit, and then Properties.

  3. In the Database Properties window, select the General tab.

  4. Expand the Data retrieval buffers node.

  5. For Buffer size and Sort buffer size, enter values, in kilobytes.

  6. Click Apply.

Related Information

Related Commands