933 - Hyperion Interactive Reporting 11.1.2: Design Reports & Dashboards Ed 1

This course focuses on two main development tasks: Query and report building, and dashboard building. You learn to create queries against a relational data source and create reports with Hyperion Interactive Reporting Studio. You begin with a pre-built data model and then learn to request items, filter and sort data, and process queries. Next, you use the results data to create tabular, cross-tabular, chart, and band-style reports.

You examine the benefits of dashboards and the default feature set provided in Dashboard Studio templates. You then create dashboards two ways. First you create dashboards with a simple dashboard template that enables you to complete the dashboard building process within Interactive Reporting Studio or Oracle's Hyperion Workspace. Second, you use a dashboard template that provides additional robust dashboard interfaces. With this template, you use both Interactive Reporting Studio and Dashboard Studio to build and configure the dashboards. This includes the use of Live Charts, Gauges other interactive objects.

Learn To:

  • Describe Oracle’s Enterprise Performance Management System
  • Query data sources
  • Create tabular, cross-tabular, chart, and band-style reports
  • Analyze report data
  • Create simple dashboards

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training


  • Describe Hyperion products
  • View Interactive Reporting documents
  • Build queries with Interactive Reporting Studio
  • Create tabular-style reports and manipulate query results
  • Create cross-tabular style reports and analyze data
  • Create a variety of chart reports and analyze data
  • Create band-style reports
  • Navigate, view and interact with documents in Workspace
  • Describe Dashboard Studio and the benefits of creating dashboards
  • Create dashboards in Workspace using the WebDash template
  • Create dashboards with Dashboard Studio
  • Configure dashboard options


Product Overview

  • Oracle’s Enterprise Performance Management System
  • Oracle Business Intelligence Suite Enterprise Edition Plus
  • Oracle Hyperion Product Components
  • Hyperion Interactive Reporting Architecture

Viewing Documents

  • Opening and Saving Documents
  • Navigating Documents
  • Refreshing Data and Organizing Sections
  • E-mailing and Printing Documents
  • Viewing Reports in Other Applications

Querying Data Sources

  • Querying Overview
  • Requesting Data
  • Filtering Data
  • Sorting Data
  • Aggregating Data
  • Controlling Query Processing

Creating Table Reports

  • Results and Table Sections Overview
  • Populating Table Reports with Data
  • Filtering Data
  • Sorting Data
  • Creating Totals
  • Formatting Data
  • Formatting Pages

Creating Pivot Reports

  • Populating Pivot Reports with Data
  • Adding Focus to Pivot Reports
  • Creating Totals
  • Formatting Data
  • Drilling into Data
  • Creating Chart Reports from Pivot Reports

Creating Chart Reports

  • Populating Chart Reports with Data
  • Adding Focus to Chart Reports
  • Modifying Chart Properties
  • Formatting Data
  • Drilling into Data
  • Creating Pivot Reports from Chart Reports

Creating Band-Style Reports

  • Populating Band-Style Reports with Data
  • Adding Focus to Band-Style Reports
  • Displaying Totals
  • Modifying Report Properties
  • Formatting Data
  • Adding Graphics to Reports
  • Embedding Pivot and Chart Reports
  • Formatting Pages

Workspace Overview

  • Workspace Modules
  • 508 Compliance
  • Opening, refreshing and saving documents
  • Synchronizing repository content
  • Importing a report into workspace
  • Roles and adaptive States
  • Users and groups

Dashboards Overview

  • Dashboard Types
  • Dashboard Benefits
  • Dashboard Content
  • Dashboard Features

Creating Dashboards in Workspace with the WebDash Template

  • WebDash Template Overview
  • Importing Documents into the WebDash Template
  • Build Dashboard Configuration Frame
  • Creating Local Filters
  • Creating Frames
  • Populating Frames
  • Modifying Frames
  • Viewing Dashboards

Creating Dashboards with Dashboard Studio

  • Dashboard Studio Wizard Overview
  • Creating and Populating Frames
  • Configuring Navigation
  • Configuring Filter Drop-down Lists
  • Configuring Dashboard Properties
  • Configuring Styles
  • Saving Master Documents

Configuring Dashboard Options

  • Creating Quick Filters
  • Creating Quick Slices
  • Creating Spotlighted Charts
  • Creating Links to Related Documents
  • Creating Wide Views
  • Configuring Hidden Facts in Pivot Reports
  • Configuring Sort Options in Pivot and Chart Reports
  • Creating Annotations

Creating Gauges and Live Charts

  • Selecting dashboard gauge types
  • Creating active dashboard reports
  • Configuring shortcut menus
  • Manipulating active dashboard reports


  • Analyst
  • Developer





This course is not associated with any Certification.

Course Benefits

  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses


This training is the first step in mastering MySQL, the world’s most popular open source database.


P10380 - Oracle Database 18c: Administration Workshop


Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.


D83527 - Java SE 8 Fundamentals
Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy