Hyperion Intelligence 8.3: Design Reports & Dashboards

Description:

This course is designed to teach you the essentials of querying relational and multidimensional databases, building reports and dashboards, and analyzing data with Hyperion Intelligence Dashboard Builder and either Hyperion Intelligence Explorer or Hyperion Intelligence Designer. You advance your skills from beginner level to intermediate level report developer. Exercises help you practice the skills taught.

Audience:

Developer

Objectives:

• Query relational databases using prebuilt data models
• Query multidimensional databases
• Analyze data
• Create tabular, cross-tabular, chart, and free-form reports
• Create simple computed items
• Create simple dashboards

Prerequisites:

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

Topics:

Hyperion Intelligence Overview
Business Intelligence Overview
Product Overview
Hyperion Intelligence Licenses
Hyperion Intelligence General Architecture

Manipulating BQY Documents
BQY Documents
Hyperion Intelligence Tools Interface
Opening and Closing Local BQY Documents
Opening BQY Documents in the Browse Module
Opening BQY Documents in a Document Repository
Exporting Report Sections
Adding, Duplicating, and Deleting Sections
Sending Documents as E-mail Attachments

Querying Relational Databases
Query and Report-Building Process
Data Models
Adding Query Sections to BQY Documents
Investigating the Underlying Data and Building the Request Line
Limiting Queries and Sorting Data on the Database
Applying Data Functions to Request Items
Optimizing the Query-Building Process

Manipulating Results and Creating Tabular Reports
Results and Table Sections Overview
Formatting Data and Sorting Data
Suppressing Duplicate Values
Applying Local Limits
Creating Date Groups and Grouping Columns
Removing and Hiding Data
Creating Grand Totals and Break Totals
Importing Data from Files

Creating and Analyzing Pivot Reports
Creating, Formatting and Sorting Pivot Reports
Creating Totals
Creating Charts from Pivot Reports
Modifying Data Functions Applied to Fact Items
Drilling into Data
Spotlighting Values in Pivot Reports
Grouping, Focusing, and Hiding Labels

Creating and Analyzing Charts
Creating Charts
Formatting Charts and Modifying Chart Properties
Setting Export Properties
Creating Pivot Reports from Charts
Analyzing Chart Data

Creating Free-Form Reports
Creating Reports in the Report Section
Formatting Reports
Adding Totals to Report Group Headers
Sorting Reports
Focusing On and Hiding Reporting Group Labels
Modifying Data Functions
Spotlighting Values
Embedding Pivot Reports and Charts

Querying Multidimensional Databases
OLAP, Metadata, and Multidimensional Databases
Navigating the OLAP Query Section
Creating and Processing OLAP Queries
Formatting in the OLAP Query Section
Sorting and Filtering Data
Specifying Slicers
Drilling into Data
Charting OLAP Query Sections

Creating Computed Items
Computed Items Overview
Creating Computed Items in the Query Section
Creating Computed Items in the Results and Table Sections
Creating Computed Items in the Pivot Section
Creating Computed Items in the Chart Section
Creating Computed Items in the Report Section

Creating Dashboards
Dashboards Overview
Building Dashboards

Customizing Dashboards
Customizing Graphics in the Dashboard Template
Creating Annotations
Creating Data Labels for Auto Z/Top Axis Items
Creating Spotlighted Charts

Managing BQY Documents
Adding BQY Documents to Dashboard Templates
Combining BQY Documents

Exercise: Plan and Build a Dashboard
Combining BQY Documents
Combining BQY Documents
Building a Dashboard