Free Sample
+ Collection
Code Files

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

Starting
Edward J. Cody

Quickly master the extremely robust and powerful Oracle Hyperion Interactive Reporting 11 tool with this book and eBook
$29.99
$49.99
RRP $29.99
RRP $49.99
eBook
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 139781849680363
Paperback232 pages

About This Book

  • Get to grips with the most important, frequently used, and advanced features of Oracle Hyperion Interactive Reporting 11
  • A step-by-step Oracle Hyperion training guide packed with screenshots and clear explanations
  • Explore the features of Hyperion dashboards, reports, pivots, and charts
  • Learn how to build advanced data models and queries, and how to import external data set into your analysis

Who This Book Is For

This book is for all Oracle Hyperion Interactive reporting users from novice to advanced. If you find yourself struggling while using this tool or you are new to the tool, this book will guide you through and make the learning process incremental.

Table of Contents

Chapter 1: Oracle Hyperion Interactive Reporting
The Interactive Reporting document: The BQY
The EPM Workspace
The Web Client interface
Saving documents
Importing BQY documents into the EPM Workspace
Editing Interactive Reporting file properties
Summary
Chapter 2: The Query
The Query section layout
Working with pre-built data models
Building a query
Filters
Sorting
Query processing
Query options
Identifying metadata (table and column remarks)
Summary
Chapter 3: The Data Model
Creating a data model
Adding tables to the data model
Working with meta topics
Updating the data model
Combining multiple queries in one model
Local results
Importing external data
Importing custom SQL files
Summary
Chapter 4: Advanced Querying and Filtering
Structured Query Language (SQL)
Advanced request items
Modifying column definitions
Advanced filtering
Custom SQL and custom join conditions
Combining queries
The query log and exporting SQL
Summary
Chapter 5: Results and Tables
Results section
The Tables sections
Adding and modifying content
Filters
Sorting
Creating totals
Grouping columns
Computed items
Summary
Chapter 6: Pivots
Creating Pivot sections
Adding content
Removing content
Arranging label content
Managing label and data headings
Sorting
Analyzing content
Totals and computed items
Formatting and conditional formatting
Exporting and printing
Summary
Chapter 7: Charts
Creating Chart sections
Adding content
Removing content
Chart types
Legend
Data functions
Analyzing content
Sorting Chart labels
Chart formatting and properties
Grouping and computed items
Exporting charts
Summary
Chapter 8: Reports
Creating Report sections
An overview of the Report layout
Adding content
Resource Manager
Building Report tables
Report groups
Creating and modifying expressions
Combining data from multiple queries
Exporting and printing
Summary
Chapter 9: Dashboards
Creating Dashboard sections
Understanding the Dashboard layout
Dashboard objects
Building a dashboard
Configuring gauges
Configuring live charts
Working with controls
Building an interactive dashboard
Exporting and printing
Summary

What You Will Learn

  • Navigate the Workspace with examples for importing and provisioning Interactive Reporting documents
  • Learn to build data models and queries, and import external data
  • Gain in-depth understanding of leveraging user-defined SQL in the product
  • Learn to analyze data in the Result, Table, and Pivot sections
  • Explore the different chart types and methods for adding chart content
  • Build report sections including data from multiple queries and different charts and pivots
  • Create interactive dashboards and configure interactive components

In Detail

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.

Authors

Read More

Recommended for You

Oracle Hyperion Interactive Reporting 11 Expert Guide
$ 32.99
Applied SOA Patterns on the Oracle Platform
$ 35.99