Copying and Pasting Views From Oracle BI to Office

You can copy and paste views from Oracle Business Intelligence Answers 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 BI Answers.

Note:

When copying and pasting views from BI Answers 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 Business Intelligence Enterprise Edition.
  2. From BI Answers 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.