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

Quickly master the extremely robust and powerful Oracle Hyperion Interactive Reporting 11 tool with this book and eBook

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

Edward J. Cody

Quickly master the extremely robust and powerful Oracle Hyperion Interactive Reporting 11 tool with this book and eBook
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $29.99
Save 66%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$49.99
$29.99p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Code Files
Preview in Mapt

Book Details

ISBN 139781849680363
Paperback232 pages

Book Description

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

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

Authors

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

Book Details

ISBN 139781849680363
Paperback232 pages
Read More

Read More Reviews

Recommended for You

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial Book Cover
Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial
$ 35.99
$ 10.00
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial Book Cover
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
$ 35.99
$ 10.00
Getting Started with Oracle Hyperion Planning 11 Book Cover
Getting Started with Oracle Hyperion Planning 11
$ 35.99
$ 10.00
Oracle Hyperion Interactive Reporting 11 Expert Guide Book Cover
Oracle Hyperion Interactive Reporting 11 Expert Guide
$ 32.99
$ 10.00
Oracle Essbase 11 Development Cookbook Book Cover
Oracle Essbase 11 Development Cookbook
$ 35.99
$ 10.00
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology Book Cover
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
$ 35.99
$ 10.00