A doclet author can create their own stylized Excel reports (within a reference file) and insert Microsoft Office Excel report content, such as grids and charts, into their Word doclets, where the Microsoft Office Excel report content is automatically updated in the Word doclet referencing the Microsoft Office Excel report content when it is modified. The Reference file contains report content that you have identified as a named range in Excel. The named range can then be embedded in a doclet. The Reference file is attached and saved to a doclet and is associated with only that doclet.
A doclet author can create their own stylized report content in Microsoft Office Excel, such as grids and charts, and insert that content into Word doclets using reference files. The Excel report content is automatically updated in the associated Word doclet whenever the Excel file is modified. You identify embeddable content in the reference file using Excel's named ranges functionality. The named range can then be embedded in a Word doclet. The reference file is attached and saved to a doclet and is associated only with that doclet.
Reference files are similar to reference doclets in that you can define embeddable content in them. The difference is that a reference file is available to and associated with a single doclet only whereas a reference doclet is available to all doclet authors with access to the reference doclet. A single doclet can be associated with multiple reference files.
To summarize this feature in Oracle Enterprise Performance Reporting Cloud, a doclet author can:
Develop stylized reports within a Microsoft Office Excel workbook, using Oracle Smart View for Office or other data access methods
Define named ranges in the workbook; the named ranges become embeddable content candidates
Integrate named ranges within doclets
Easily update the reference file in Excel, which automatically updates the Microsoft Office Excel report content in the Word doclet with which it is associated
Incorporate multiple ranges from the same or different reference files in a Word doclet