Hyperion Interactive Reporting 11.1.1: Design Reports & Dashboards

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.

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 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

* This course is also suitable for customers using Hyperion Interactive Reporting 9.3.1.

Course Objectives:

• Create dashboards with Dashboard Studio
• Configure dashboard options
• 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

Required Prerequisites:

• Some knowledge of data warehouse and database concepts
• Familiarity with Windows conventions