Oracle Hyperion Interactive Reporting 11 Expert Guide

Learn Advanced Dashboards, JavaScript, Computations, and Special Topics from the Experts

• 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.

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.

What you will learn from this book

• 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

Approach

This book is written in a simple, easy to understand format with screenshots, code samples, and step-by-step explanations that will guide you through the advanced techniques used by the experts.

Who this book is written 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
Chapter 2: Introduction to JavaScript and the Interactive Reporting API
Chapter 3: Creating a Simple Dashboard
Chapter 4: Introducing Dashboard Interactivity
Chapter 5: Building the Dashboard Framework
Chapter 6: Advanced Dashboard Techniques
Chapter 7: Advanced Data Analysis
Chapter 8: Creating Briefing Slides and Executing Batch Exports
Chapter 9: The Central Code Repository
Chapter 10: Optimizing and Merging