Copying and Pasting Views From Oracle BI EE to Office

You can copy and paste views from Oracle Business Intelligence Enterprise Edition to Oracle Smart View for Office.

When you refresh pasted views, the data is refreshed, but the analysis definition is not, even if its definition has been modified in Oracle BI EE.

Note:

When copying and pasting views from Oracle BI EE to Smart View, some formatting may not be imported to Office.

To copy and paste a view:

  1. Ensure that you are logged into Oracle BI EE.
  2. From Oracle BI EE or Interactive Dashboards, launch the analysis that you want to copy.
  3. Click the Copy link at the bottom of the analysis (displayed only if the analysis is enabled for copying).
  4. Open an Office application, such as Excel, and connect to the appropriate Oracle BI EE data source.
  5. From the Oracle BI EE ribbon, click The Paste button.