Extended Access for Interactive Reporting enables users to jointly analyze multidimensional and relational sources in one document. It retrieves the flattened OLAP results from a Oracle Hyperion SQR Production Reporting, and Oracle Hyperion Financial Reporting query in the Reporting and Analysis repository and imports the data into the Interactive Reporting document as a results section. Extended Access for Interactive Reporting also enables:
An end user can perform quick ad-hoc analysis by drilling down, swapping and pivoting on the data to see patterns or exceptions.
The results section can be used as a new data source and can be joined with other data sources either from the database or other tables.
The end user can perform offline analysis for multidimensional data.
The Interactive Reporting document can be refreshed with multidimensional data.
The Query/Report (Oracle Hyperion Web Analysis) can be refreshed.
The latest job output/snapshot (Production Reporting and Financial Reporting) can be retrieved.
The following steps assume that a Web Analysis query (Web Analysis document), Production Reporting query (Production Reporting job output) or a Financial Reporting query (Batch report) is resident in EPM Workspace. These queries should be formatted so that their data is compatible in a relational query (flattened data), see the EPM WorkspaceUser online help.
Note: | Extended Access for Interactive Reporting does not support null values. If a null value is needed for the document, the user must convert the null value to a special value in Financial Reporting, Web Analysis and Production Reporting. Then the user must use an Interactive Reporting function to convert it back to a null value. |
Extended Access for Interactive Reporting can only be done in the Interactive Reporting Web Client application. If the Interactive Reporting Web Client application has not been installed, select Tools , then Install and then Interactive Reporting Web Client. When the Interactive Reporting Web Client Setup dialog is displayed, complete the installation.
To import a multidimensional data source into an Interactive Reporting document:
In EPM Workspace, navigate to the Interactive Reporting document to which you want to extend access for a multidimensional report.
Select the Interactive Reporting document and select Open as, then Interactive Reporting Web Client from the shortcut menu.
The selected document is displayed in the Interactive Reporting Web Client.
Navigate to the section to which you want to add the multidimensional report as a results set.
Navigate to the folder which contains the repository document.