Name: Hyperion Interactive Reporting 9.3.1: Design Reports and Dashboards
Course Code: ORHY52374
Duration: 3
Scheduled Dates for ORHY52374
This course focuses on two main development tasks: Query and report building, and dashboard building. During the first two days, 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. Finally, you learn to create additional data for your reports by creating computed items.
You begin the third day by examining 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 more robust dashboard interfaces
Target Audience
Reports Developer
Business Analysts
Key Topics
- Product Overview
- Oracle's Enterprise Performance Management System
- Oracle Business Intelligence Suite Enterprise Edition Plus
- Hyperion Product Components
- 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
- Creating Computed Items
- Computed Items Overview
- Configuring Computed Items
- Creating Grouping Columns
- Creating Computed Items with Strings
- Creating Computed Items with Dates
- Creating Computed Items with Numbers
- Modifying Null Values
- Filtering Computed Items
- 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
Objectives
- 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
- Create computed items
- 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
Required Skills/Experience
- Some knowledge of data warehouse and database concepts
- Familiarity with Windows conventions
Suggested Next Course(s)
- Hyperion Interactive Reporting 9.3.1: Design Advanced Reports
Fee: $2,250.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
