On-line training course catalogue

Hyperion Interactive Reporting 9.3.1: Design Advanced Reports

Type of course: Classroom

Course details

Fee	£1100
Days	2
Course code	HYIRDAR

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

In this course, you advance your skills to a report developer level. With the fundamentals already learned, you continue exploring, in more depth, the advanced options for creating queries and reports. This course is structured to address the various stages of the report development cycle.

You begin by creating connection files, both simple and customized, to relational and multidimensional data sources. From there, you learn the techniques for creating data models that meet various user needs in your organization. You advance your report building skills by utilizing complex features in Interactive Reporting Studio and document management features in Optimize Studio. Lastly, you learn how to make available on the Web, Interactive Reporting content, such as connection files, documents, and jobs.

 

Prerequisites

 Required Prerequisites:

• Equivalent knowledge of the subject matter covered in the Hyperion Interactive Reporting 9.3.1: Design Reports & Dashboards course

 Suggested Prerequisites:

• Knowledge of data warehouse design principles
• Working knowledge of SQL

 

Delegates will learn how to

• Configure connection files for data sources and metadata
• Create and administer data models
• Design advanced queries and reports
• Import and schedule Interactive Reporting documents on the Web
• Optimize Interactive Reporting documents

 

Course outline

 

 

Creating Connection Files

• Connection Files Overview
• Supported Database and Connection Types
• Creating Basic Connection Files
• Setting Advanced Options
• Displaying Metadata

 

Creating Data Models

• Interactive Reporting Architecture
• Report Development Process
• Database Terminology
• Star Schema Design Principles
• Adding Tables and Joining Items
• Setting Query Governors and Global Filters
• Creating Meta Topics and Master Data Models
• Synchronizing Data Models with Databases

 

Creating Complex Queries

• Creating Local Joins
• Creating Filter Local Joins
• Creating Derived Tables
• Processing Results to Database Tables
• Merging Result Sets with Query Operators
• Creating Sub queries
• Creating Correlated Sub queries
• Exporting, Importing, and Customizing SQL

 

Creating Complex Reports

• Defining Drill Paths
• Displaying Multiple Results in Band-Style Reports
• Creating Complex Computed Items

 

Importing and Scheduling Documents on the Web

• Workspace Modules
• User Provisioning Overview
• Importing Connection Files
• Importing Interactive Reporting Documents as Files
• Importing Interactive Reporting Documents as Jobs
• Running Interactive Reporting Jobs on Demand
• Scheduling Interactive Reporting Jobs
• Managing Jobs

 

Optimizing Documents

• Optimize Utility Overview
• Loading Documents into the Optimize Utility
• Renaming Sections
• Changing Parent Sections for Filters and Reports
• Changing Parents for Band-Style Reports
• Compacting Scripts