Lesson: Retrieving Data from a Database

You use Spreadsheet Add-in to request data from Essbase Server and retrieve the information into a worksheet.

  To retrieve data into a blank worksheet:

  1. Select File, and then New, or click New Worksheet icon.

    You must be connected to the Sample Basic database.

  2. Perform one action:

    • Double-click an empty cell, or press Alt+S+R.

    • Select Essbase, and then Retrieve.

    • Click Retrieve icon on the Essbase toolbar, or press Alt+S+R.

    Essbase retrieves data into the worksheet.

    Initial data retrieval from the Sample Basic database.

    Note:

    Spreadsheet Add-in does not support worksheet sizes greater than 65,536 rows by 256 columns.

    These five dimensions are retrieved: Measures, Product, Market, Scenario, and Year.

When you retrieve data into a blank worksheet, Essbase returns data from the top levels of each dimension, from which you can navigate, or drill down, to more detailed levels of data.

User Reference

Retrieving Multidimensional Data

Retrieving and Updating Data