You can use Smart View to copy data from EPM System and BI on-premises and cloud data sources, including Oracle Enterprise Performance Reporting Cloud Service data sources, and paste the data into doclets in a report package.
For example, you can incorporate data from Essbase and Oracle Enterprise Performance Reporting Cloud Service in the same doclet or different doclets within a report package. A doclet in a report package in Word may contain a profit and loss statement report that was created from an Essbase source along with an income statement report created from an Oracle Enterprise Performance Reporting Cloud Service source. The data points for the areas that you copy are retained in Word, so you can refresh the doclet to keep the data up to date.
The scenario in Example: Working with Enterprise Performance Reporting Cloud Service 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.