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, including Oracle Enterprise Performance Reporting Cloud data sources, and paste the data into doclets in a report package.
For example, you can incorporate data from Oracle Essbase and Enterprise Performance Reporting Cloud 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 Enterprise Performance Reporting Cloud 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 Enterprise Performance Reporting Cloud 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.