Working with Narrative Reporting Data in Smart View

You can use Oracle Smart View for Office to copy data from Oracle Enterprise Performance Management System and Oracle Business Intelligence on-premises and cloud data sources,.

This includes Narrative Reporting data sources, and paste the data into doclets in a report package.

For example, you can incorporate data from Oracle Essbase and Narrative Reporting in the same doclet or different doclets within a report package. A doclet in a report package in Word or PowerPoint may contain a profit and loss statement report that was created from an Essbase source along with an income statement report created from an Narrative Reporting source. The data points for the areas that you copy are retained in Word or PowerPoint, so you can refresh the doclet to keep the data up to date.

The scenario in Example: Working with Narrative Reporting Data in Smart View demonstrates using ad hoc analysis in Excel to create a report, and then copying the data points from that report and pasting them into a doclet in Word.