Book Image

The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11

By : Edward Cody
Book Image

The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11

By: Edward Cody

Overview of this book

Oracle Hyperion Interactive Reporting is one of the many products in the Oracle Enterprise Performance Management software suite, an industry-leading business intelligence software package. The primary focus of the Interactive Reporting product is to provide strong relational querying and data analysis capabilities. It also provides the capability to disseminate information throughout an enterprise. There is a very steep learning curve for most users of this tool.This book examines the power of the Interactive Reporting Web Client software, focusing on the key features of each section of the product. The author's experience in developing and supporting Interactive Reporting users is very well documented in this book. The goal is to educate you on every useful feature of the product, enabling you to gather information from various sources and process it to produce meaningful results that help you to spot problems and analyze trends necessary for business decisions.The book starts with a quick introduction to the product interface and the EPM Workspace, with explanation of importing and provisioning. It then takes you through each section from building a query and data model to building graphical displays of the data in a logical sequence. The report sections and interactive dashboards are also discussed at length. The book also covers advanced features of the product and provides you with the information necessary to build the foundation for creating complex queries and computations using the product.
Table of Contents (16 chapters)
The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11
Credits
About the Author
Acknowledgement
About the Reviewer
Preface
Index

Editing Interactive Reporting file properties


After files are posted to the Workspace, files can be edited to change file permissions, to change database connection files, to change file attributes, and to post new versions of the document. To change the file properties in the Workspace, right-click on the file and select Properties. The Properties window appears and displays the General Properties as shown in the following screenshot:

The navigation to other options is displayed on the left side of the window, where the different buttons can be clicked to bring up the different file properties. The Permissions, Advanced, and Interactive Reporting properties (database connection) screens mimic the screens shown during the importing of a file, and the settings saved from the most recent edit of the file properties will be populated in each section.

The General Properties window is used to change the Name, Description, and Owner of the file. Also included in this section is the SmartCut, the URL to the document that can be pasted into a web browser or sent in an e-mail. The SmartCut changes with modifications to the file path or the filename, and the default URL opens the file in the HTML view of the document.

Note

To open a SmartCut in the Interactive Reporting Web Client, add a ?bqtype=plugin to the end of the URL.

The Versions tab can also be used to manage file versions. As versions are added, additional rows are added to the Versions window as shown in the following screenshot. To post an updated file to one of the versions, click on the Replace button next to the version of interest. To add a new version to the file, click on the Add New Version button at the bottom-left of the window. Click on the Modify link to update the connection or general version properties, and click on the Delete button to remove a version: