1. Working with Oracle Smart View for Office
  2. General Operations
  3. Copying and Pasting
  4. Viewing Cell POV and Server Information for Pasted Data Points

Viewing Cell POV and Server Information for Pasted Data Points

After copying and pasting data points from Microsoft Office applications, and then refreshing the Office document, you can select data points and view the POV and source server information.

This procedure applies to data points copied from Excel and pasted to Excel, Word, or PowerPoint, or copied and pasted between Word and PowerPoint.

To view the POV and source server information of a pasted data point:

  1. In the target Office document, select the data point.
    For example, if you copied and pasted an ad hoc grid from Excel to Word, then in Word, select a data point within the pasted and refreshed grid. In some cases, double-clicking the cell may be sufficient, but if there a decimal point in the cell, then you must select it manually.

    The cell POV and server information is displayed as hover text, as shown in Figure 17-10.

    Figure 17-10 Pasted Grid Showing Hover Text Over Selected Data Cell


    Shows a cell selected in a pasted grid with hover text showing connection information (server, application, cube, URL, and provider), POV information (dimensions and members), and alias table used (in this case, Default).
  2. To close the hover text, click anywhere on your screen.