Viewing Visual Explorer Data from Microsoft Office

  To view data in Excel using Visual Explorer:

1. Open a worksheet in Excel.

2. Connect to an Essbase data source.

3. Create a report or use an existing one.

4. Depending on your Office application:

   • Excel: From the Essbase ribbon, select Visualize, then Visualize in HVE.

   • Word or PowerPoint: From the Smart View ribbon, select Visualize in HVE.

   The Visual Explorer interface is displayed (you may be prompted to sign in).

5. From Show Me!, select a graphical format and click OK.

   Oracle Essbase Visual Explorer displays the spreadsheet associated with the data cells in graphical forma