Book Image

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

By : Edward Cody
Book Image

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

By: Edward Cody

Overview of this book

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.

Related Content you might be interested in

Current Title:

Small book image
The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11
Edward Cody
Sep, 2010 | 232 pages
No titles found
Table of Contents (16 chapters)
The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11
The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11
Credits
Credits
About the Author
About the Author
Acknowledgement
Acknowledgement
About the Reviewer
About the Reviewer
Preface
Preface
Free Chapter
1
Oracle Hyperion Interactive Reporting
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
2
The Query
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
3
The Data Model
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
4
Advanced Querying and Filtering
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
5
Results and Tables
Results and Tables
Results section
The Tables sections
Adding and modifying content
Filters
Sorting
Creating totals
Grouping columns
Computed items
Summary
6
Pivots
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
7
Charts
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
8
Reports
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
9
Dashboards
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
Index
Index

About the Author

Edward J. Cody is accomplished Data Warehouse and Business Intelligence consultant with over seven years of experience with Hyperion products. Mr. Cody was a speaker at Oracle OpenWorld 2008 on Essbase, and he has spoken at local user groups on ETL software. His experience with Interactive Reporting began with Brio v6 and has continued through the most recent version. He also has extensive experience with Essbase and Financial Reporting.

Mr. Cody has consulted both private and Government organizations throughout his career. He has a Bachelor of Science in Systems Engineering from the George Washington University, School of Engineering and Applied Science, and he has a Master of Science in the Management of Information Technology from the University of Virginia, McIntire School of Commerce. His experience includes leading large Data Warehouse and Oracle Hyperion Business Intelligence projects, and he is currently leading an assessment of a major data warehouse and business intelligence initiative. He is well know for his efforts to aid clients in realizing their investment in business intelligence and a data warehouse through building well designed systems, leveraging automation, and reducing BI complexity.

Mr. Cody has designed training programs on the software and decided to author a book on Oracle Hyperion Interactive Reporting after exposure to user feedback on the complexity of learning the product. He identified that an introductory user guidebook on using the essential features of the software would be beneficial to all software users.

Previous Section
Next Chapter