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.


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