Retrieving Data Using Visual Explorer

Visual Explorer enables users to transfer data from the Visual Explorer interface to an Excel worksheet at any time. After you create a view of data in Visual Explorer, you can transfer the underlying data to the active Excel worksheet by using the Update Excel command.

You can also transfer data to a worksheet within the active Excel workbook using the Update Excel (New Worksheet) command.

*  To retrieve data from Visual Explorer into a worksheet in Spreadsheet Add-in:

  1. In Visual Explorer, select File.

  2. Perform one action:

    • To retrieve data into the active worksheet, select Update Excel or click Update Excel icon..

    • To retrieve data into a new worksheet within the active Excel workbook, select Update Excel (New Worksheet) or click Update Excel (New Worksheet) icon..

  3. View the data in the Excel worksheet.

Notes:

Related Topics

Essbase System Login Dialog Box for Visual Explorer

Launching Visual Explorer

Logging In to Essbase from Visual Explorer

Retrieving Multidimensional Data Using Visual Explorer