Hyperion Interactive Reporting: Design Reports and Dashboards

QA Ltd.
Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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. With this template, you use both Interactive Reporting Studio and Dashboard Studio to build and configure the dashboards.



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


Delegates will learn how to
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


Course outline


Product Overview

Oracles 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
...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

TEL: 0844 871 2080
E-mail us: info@qa.com

Jobs & Resumes: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Houses & Roommates: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Travel Agencies: Birmingham, Bristol, Edinburgh, Leeds, London, Manchester,

Search other schools for Hyperion Interactive Reporting: Design Reports and Dashboards training resources.

Hyperion Financial Management 1
Hyperion Financial Management 2
Hyperion Financial Management 3
Hyperion Financial Management 4
Hyperion Financial Reporting for Financial Management
Hyperion Financial Reporting for Essbase and Planning
Hyperion Interactive Reporting: Design Advanced Reports
Hyperion Master Data Management Administration
Hyperion Planning for Interactive Users
Hyperion Planning Installation and Configuration
Hyperion Smart View for Essbase
Hyperion Smart View for Financial Management
Hyperion Web Analysis: Design Reports
AIX 5L TCP/IP I: Configuring
AIX Basics
AIX Jumpstart for UNIX Professionals

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.