Oracle Hyperion Interactive Reporting

Have Queries? Ask us +91 72592 22234

Course Overview

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. The product is extremely flexible and provides analysts with the ability to quickly analyze data and produce deliverables. The tool also provides a consistent platform for managing content, where documents can be customized, saved, and shared across an organization.

Course Content

Introduction to Interactive Reporting Studio

  • Overview
  • Interactive Reporting Studio Features
  • How Interactive Reporting Studio Works
  • Relational Databases
  • Multidimensional Databases
  • About Interactive Reporting Documents
  • Data Source Connections
  • Data Models
  • Queries
  • Analysis and Reporting
  • Turning Data into Information

Getting started with Reporting Studio

  • Starting the Interactive Reporting Studio
  • Opening and Saving a Sample File
  • Looking at a Simple Query
  • Viewing Database Tables
  • Adding Topics to a Query
  • Viewing Results
  • Reordering Columns
  • Sorting Columns
  • Filtering Data
  • Calculating Data
  • Pivoting Data
  • Calculating Totals and Subtotals
  • Drilling Down
  • Hiding Data
  • Adding Color
  • Charting Data
  • Sorting Charts
  • Inserting Text Labels
  • Designing Reports
  • Creating Smart Reports
  • Sorting Columns
  • Setting Up a Report Page

Understanding the Reporting Studio Features

  • Using the Interactive Reporting Workspace
  • Main Menu
  • Toolbars
  • Section Title / Status Bar
  • Command Lines
  • Data Layout
  • Section / Catalog / Content Pane
  • Managing / Maintaining / Saving Documents
  • Working with Data Sources
  • Exporting Data
  • Custom Formulas
  • Formatting Text and Other Elements
  • Document Properties
  • Interactive Reporting Web Client Co-existence
  • Interactive Reporting Web Client Mismatches
  • Tools Menu Command Reference

Querying Relational Databases

  • Using Data Models in the Query Section
  • Building Queries
  • Query Processing Order
  • Building Subqueries
  • Derived Tables Rules and Behavior
  • Working with Query Section Data
  • Estimating Query Size
  • Preaggregating Data Using Functions
  • Using Stored Procedures
  • Importing Data Files
  • Setting Data Type Properties

Working with Query Results

  • Results Section
  • Understanding Data Types
  • Enhancing Your Results Set
  • Adding Computed Items to Results
  • Grouping Columns
  • Working with the Results Table

Working with Tables

  • Creating Tables
  • Tables as a Data Staging Area
  • Adding Computed Items
  • Grouping Columns
  • Applying Data Functions to Tables
  • Working with Table Components

Querying Multidimensional Databases

  • OLAPQuery Section
  • Building OLAP Queries
  • OLAPQuery Member and Level Rules
  • Specifying a Slicer
  • Using OLAPQuery Functions
  • Processing OLAP Queries
  • Applying Filters
  • Setting Drill-through Options

Analyzing Data with Pivot Tables

  • Working with Pivot Tables
  • Using Data Calculations in Pivot Tables
  • Using Weighted Averages
  • Pivot Section Aggregation and Surface Values


  • Working with Two-dimensional Charts
  • Working with Three-dimensional Bar Charts
  • Customizing Chart Properties

Report Designer

  • Creating a Custom Report
  • Adding Report Groups
  • Working with a Report Page
  • Using Grids
  • Using Multiple Data Sources in a Report
  • Creating Smart Reports
  • Converting Detail Reports from Versions Earlier than 6

Using Filters

  • Server versus Local Filter Processing
  • Filtering Queries
  • Filtering Results
  • Setting Compound Filters
  • Setting Variable Filters
  • Multiple Filters and the Meta Topic
  • The Two-Tier Strategy

Working with Computed Items

  • Computing New Data
  • Computed Items and Data Functions
  • Pivot Options
  • Using Functions
  • Positioning of Moving Average Results - Trailing and Centered Averages

Applying Sorts

  • Simple Sorts
  • Complex Sorting
  • Complex Sorting in the Query, Results, and Table Sections
  • Complex Sorting in Chart, Pivot, and OLAPQuery Reports

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234