Book Image

Oracle Hyperion Interactive Reporting 11 Expert Guide

By : Edward J. Cody, Emily M. Vose, Emily Vose, Edward Cody
Book Image

Oracle Hyperion Interactive Reporting 11 Expert Guide

By: Edward J. Cody, Emily M. Vose, Emily Vose, Edward Cody

Overview of this book

Oracle Hyperion Interactive Reporting is one of many products in the Oracle Business Intelligence Enterprise Edition Plus software suite, an industry-leading business intelligence platform. The primary focus of the Interactive Reporting product is to provide strong relational querying and data analysis capabilities, where the software provides significant flexibility for creating custom dashboards, interfaces, and data analysis routines through the use of JavaScript programming and built-in software functionality. While Interactive Reporting is extremely flexible, performing advanced operations in the software is complicated and requires basic programming knowledge and an advanced understanding of the software. This book continues from where The Business Analyst’s Guide to Oracle Hyperion Interactive Reporting 11 completed and provides the reader with the information to successfully execute the advanced features of the product along with examples and specific techniques applicable to everyday use. The Oracle Hyperion Interactive Reporting 11 Expert Guide provides software users and developers with many examples of the techniques used by software experts. The book begins with an introduction to leveraging advanced features of the project and an introduction to JavaScript. Dashboards are a major focus of the book with four chapters focused on building a simple to complex dashboard including functions, global objects, and syncing selections across dashboards. The book places an emphasis on learning methods for data analysis by using advanced programming and built-in functions, and a unique approach to using code to generate batch reports and exports is provided. The Dashboard Studio Optimize Utility and the Dashboard Studio Merge utility are explained in detail, and the approach to building and using a central code repository for use in dashboards and computations across multiple documents in an enterprise is demonstrated. This book will help the reader become an expert user of the software, providing the skills necessary to understand, communicate, and perform advanced level tasks. The authors’ experience in developing and supporting Interactive Reporting users is very apparent throughout each chapter of the book. While the book displays content and examples from version 11 of the software, the book is also applicable to previous versions of the software dating back to version 8, so readers not currently using Interactive Reporting 11 will find the book applicable to daily use with the product.
Table of Contents (18 chapters)
Oracle Hyperion Interactive Reporting 11 Expert Guide
Credits
About the Authors
Acknowledgments
About the Reviewers
www.PacktPub.com
PacktLib.PacktPub.com
Preface

Review of Interactive Reporting sections


Before identifying where the advanced features of the product can be leveraged in the document, it is important to review the different sections of the software. The following list provides an overview of each section of the Interactive Reporting software:

  • The Data Model and Query sections are used to model database objects and build queries from a data source.

  • Each Query section is accompanied by a Results section where data returned from a query is displayed, filtered, and computed. There is only one Results section per Query section, and each Results section displays data in a row by column format.

  • Table sections are similar to Results sections and are used to manipulate and split a set of results into different subsets for analysis. Each table section is specific to a set of results and multiple table sections can be created.

  • A Pivot section is a common presentation section in Interactive Reporting that aggregates data in a row by column format and the pivot functionality is similar to Microsoft Excel pivots. The Pivot section can use any column of data from the parent Results or Table section.

  • A Chart section is another presentation section of the document. The Chart section is commonly used to display data in a graphical format. Different chart formats exist, ranging from bar and pie charts to scatter and bubble charts.

  • The Report section provides the ability to present charts and tables of data in a printable report format. The Report section is the only section of the document that allows for the addition of data from multiple queries in the document into a single reporting object, and reports provide an additional method of splitting out data by Report Groups.

  • Dashboards are used to create custom interfaces or interactive displays of key metrics. The dashboard section provides the flexibility to leverage custom scripting and interactivity to automate manual features of the product.