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.
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: