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 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 Working with Reports in Smart View in Working with Reports for Oracle Enterprise Performance Management Cloud.
Note:
Before you begin, launch Smart View in Excel and connect to a supported Oracle Enterprise Performance Management Cloud data source as described in Connecting to Data Sources.
To import a report in to Smart View as an ad hoc query: