Importing Reports as Ad Hoc Queries
You can import Reports in to Oracle Smart View for Office as ad hoc queries, on which you can then perform available ad hoc operations. The ad hoc grids you create can be saved and used as embedded content in your report package doclets.
The procedure in this topic describes importing Reports as ad hoc grids starting in Smart View for Excel. You can also use the "Download as Excel Ad Hoc" command in your web application to import Reports as ad hoc grids in to Smart View for Excel, described in Viewing Reports in Working with Reports for Oracle Enterprise Performance Management Cloud.
Note:
Before you begin, launch Smart View in Excel and log in to Narrative Reporting.
To import a report in to Smart View as an ad hoc query: