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

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

Credits

About the Author

Acknowledgement

About the Reviewer

Preface

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

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

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

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

Results and Tables

Results section

The Tables sections

Adding and modifying content

Filters

Sorting

Creating totals

Grouping columns

Computed items

Summary

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

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

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

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