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

Analyzing content


The Chart section also provides analysis tools similar to the Pivot section, where the Chart is interactive and can be manipulated during analysis. The Chart section provides the ability to Focus, Hide, and Drill into the non-fact data elements to explore datasets.

Note

Scatter and Bubble charts do not allow the use of any of the features of this section except the Hidden Item feature.

Drill

The non-fact items in the chart can be drilled into similar to drilling into a Pivot. Use one of the following two steps to drill into a Chart:

Right-click method

Chart menu method

Highlight the label of the element(s) in the chart (x-axis or z-axis)

Highlight the element(s) in a row or column label

Right-click and highlight Drill Anywhere

Open the Pivot menu and highlight Drill Anywhere

Select the element to drill into

Select the element to drill into

Drillup

The following steps are used to reverse the Drill behavior and Drillup on chart elements:

Right-click method

Chart...