Free Sample
+ Collection

Oracle Hyperion Interactive Reporting 11 Expert Guide

Edward J. Cody, Emily M. Vose

Master advanced Dashboards, JavaScript and Computation features to Oracle Hyperion Interactive Reporting 11 and much more
RRP $32.99
RRP $54.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849683142
Paperback276 pages

About This Book

  • Walk through a comprehensive example of a simple, intermediate, and advanced dashboard with a focus on Interactive Reporting best practices.  
  • Explore the data analysis functionally with an in-depth explanation of built-in and JavaScript functions.  
  • Build custom interfaces to create batch programs and exports for automated reporting.  
  • Demonstrate expertise by learning to build a central code repository.
  • Explore merging through the Dashboard Studio and the beneficial features of the Dashboard Studio Optimize Utility.
  • Become an expert by mastering the concepts and examples presented in this book.


Who This Book Is For

If you are an Oracle Hyperion Interactive reporting user or developer looking to become an expert in the product, then this book is for you. You will require a basic knowledge of Interactive Reporting, as this book starts with a brief overview and then dives into advanced techniques, functions, and best practices.  Beginner users should consult The Business Analyst’s Guide to Oracle Hyperion Interactive Reporting 11 to gain insight on the software product.

Table of Contents

Chapter 1: Advanced Hyperion Interactive Reporting Techniques
Introduction to the Oracle Hyperion Interactive Reporting 11 Expert Guide
The EPM Workspace
Interactive Reporting interface and components
Review of Interactive Reporting sections
Leveraging code
The Scripting Interface
Chapter 2: Introduction to JavaScript and the Interactive Reporting API
Introduction to objects and collections
The Script Editor
Introduction to JavaScript
Chapter 3: Creating a Simple Dashboard
Dashboard planning and preparation
The BMV USA Executive Dashboard Example
Creating data-driven dashboard objects
Creating a simple dashboard
Live Charts
Chapter 4: Introducing Dashboard Interactivity
Dashboard Section Objects
Creating a Master Dashboard
Creating Supporting Dashboard Sections
Document Start-up Scripts
Chapter 5: Building the Dashboard Framework
Understanding the Dashboard Framework
Implementing the Dashboard Framework
Understanding Document Save Options
Chapter 6: Advanced Dashboard Techniques
Populating Dashboard Controls with Database-Driven Values
Applying User-Selected Filters to Limit Data
Synchronizing User Selections across Multiple Dashboards
Chapter 7: Advanced Data Analysis
Building Queries for Analysis
Computed Items
Built-in Functions and Calculations
Using JavaScript
Chapter 8: Creating Briefing Slides and Executing Batch Exports
Exporting document sections
Briefing slides
Executing batches of reports
Chapter 9: The Central Code Repository
Understanding the Central Code Repository
Configuring the CCR code table and query
Building the Global Code Dashboard
Advanced concepts
Chapter 10: Optimizing and Merging
The Dashboard Studio
Dashboard Studio: Merging sections
The Dashboard Studio Optimize Utility

What You Will Learn

  • Introduction to JavaScript and programming in Interactive Reporting
  • Simple to complex dashboards and methods used by developers to build advanced interfaces
  • Advanced techniques for building computed items with built-in and JavaScript functions
  • Leverage Report sections to create briefing slides and custom programming to build batch exports
  • Merging and modifying a document with the Dashboard Studio and Dashboard Studio Optimize Utility
  • Create a centralized code database for use across multiple Interactive Reporting documents in the enterprise


In Detail

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.


Read More

Recommended for You

The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11
$ 29.99
Applied SOA Patterns on the Oracle Platform
$ 35.99