Introduction to Hyperion Designer

Request more details:

submit request
Description:
This is a comprehensive, hands-on introduction to effectively using Hyperion. The course focuses on Query and report building, analysing and charting data. Participants learn to create queries against a relational data source and create reports with Hyperion Interactive Reporting Studio
Prerequisites:
Prerequisites
Some knowledge of data warehouse and database concepts
Familiarity with Windows conventions
Introducing Hyperion Designer :
Overview
Interactive Reporting Studio Features
How Interactive Reporting Studio Works
Relational Databases
Multidimensional Databases
About Interactive Reporting Documents
Data Source Connections
Data Models
Queries
Analysis and Reporting
Turning Data into Information
Interactive Reporting Studio: A Tutorial :
Starting the Interactive Reporting Studio
Opening and Saving a Sample File
Looking at a Simple Query
Viewing Database Tables
Adding Topics to a Query
Viewing Results
Reordering Columns
Sorting Columns
Filtering Data
Calculating Data
Pivoting Data
Calculating Totals and Subtotals
Drilling Down
Hiding Data
Adding Color
Charting Data
Sorting Charts
Inserting Text Labels
Designing Reports
Creating Smart Reports
Sorting Columns
Setting Up a Report Page
Interactive Reporting Studio Basics:
Using the Interactive Reporting Workspace
Main Menu
Toolbars
Section Title Bar
Command Lines
Data Layout
Section Pane
Catalog Pane
Content Pane
Status Bar
Managing Documents
Maintaining Documents
Saving Documents
Specifying Save Options
Working with Data Sources
Exporting Data
Exporting to Microsoft Office HTML File Formats
Formula Mappings
Custom Formulas
Exporting a Document as a Web Page
Printing Documents
Sending Documents
Quitting an Interactive Reporting Studio Session
Quitting the Interactive Reporting Web Client
File Menu Command Reference
Using Edit Commands
Changing Workspace Views
Inserting Sections and Breaks
Formatting Text and Other Elements
Formatting Numeric Data Types
Changing Numeric Formatting
Displaying Numbers in Scientific Notation
Working with Document Sections
Understanding Document Sections
Adding Sections
Viewing Sections
Moving Between Sections
Duplicating Sections
Renaming Sections
Adding Headers and Footers to Sections
Deleting Sections
Setting Options
Specifying Default Formats
Selecting Program Options
Document Properties
Customizing Menus
Tools Menu Command Reference
Interactive Reporting Web Client Co-existence
Locally Saved BQYs
Interactive Reporting Web Client Mismatches
Querying Relational Databases :
Query Section
Using Data Models in the Query Section
Building Queries
Working with Items on the Request Line
Processing Queries
Query Processing Order
Saving Queries
Cancelling Queries
Building Subqueries
Regular Subqueries
Correlated Subqueries
Derived Tables
Derived Tables Rules and Behavior
Derived Tables and SQL
Working with Query Section Data
Processing Results to a Database Table
Estimating Query Size
Displaying Database Remarks
Preaggregating Data Using Functions
Appending Queries
Using Local Results
Using Stored Procedures
Setting Query Options
Importing Data Files
Setting Data Type Properties
Query Menu Command Reference
Working with Query Results :
Results Section
Understanding Data Types
Enhancing Your Results Set
Filtering Results
Sorting Results Data
Adding Computed Items to Results
Applying Data Functions to Results
Adding Grouping Columns
Modifying Grouped Columns
Adding Columns Automatically
Breaking Out Dates
Working with the Results Table
Selecting Columns and Rows
Deleting Columns
Formatting Commands
Saving Results Sets
Exporting Result Sets
Results Menu Command Reference
Working with Tables :
Table Section
Creating Tables
Tables as a Data Staging Area
Manipulating Table Data
Filtering Data in a Table
Sorting a Table
Adding Computed Items
Adding Grouping Columns
Modifying Grouping Columns
Adding Date Groups
Applying Data Functions to Tables
Working with Table Components
Selecting Columns and Rows
Deleting Columns
Table Menu Command Reference
Analyzing Data with Pivot Tables :
Pivot Section
Creating a Pivot Table
Pivoting Data
Charting a Pivot Table
Working with Pivot Tables
Selecting Pivot Table Elements
Moving Pivot Table Elements
Changing Label Nesting Levels
Sorting Pivot Tables
Using Data Calculations in Pivot Tables
Adding Totals and Subtotals
Adding Cumulative Totals
Using Data Functions
Using True Computed Item Totals
Using Surface Values in Data Functions
Using Weighted Averages
Adding Computed Items
Pivot Section Aggregation and Surface Values
Fact Detail Cells
Pivot Fact Detail Cell Behavior
Pivot Section Computed Items
Computed Item Detail Cell Values
Pivot Menu Command Reference
Charting Data:
Chart Section
Charting Basics
Chart Terminology
Understanding Chart Dimensions
Using the Chart Data Layout
Creating Charts
Selecting a Chart Type
Working with Two-dimensional Charts
Using Pie Charts to Analyze Data
Using Two-dimensional Bar Charts to Analyze Data
Working with Multidimensional Charts
About the 3-D View
Creating Three-dimensional Bar Charts
Understanding Clustered Bar Charts
Understanding Stacked Bar Charts
Understanding Area Charts
Understanding Ribbon Charts
Understanding Line Charts
Understanding Combination Charts
Manipulating Chart Data
Using Different Scales to Compare Related Values
Using Data Functions in Charts
Adding Computed Items
Sorting Chart Items
Creating Pivot Tables from Charts
Drilling into Charts
Hiding and Focusing on Charted Data
Restoring Hidden Items
Working with Chart Elements
Selecting Chart Elements
Displaying Axis Grid Lines
Inserting Text
Changing Chart Legends
Chart Scrolling and Scaling
Scrolling through Chart Data
Rotating and Elevating Charts
Smart Scaling
Initial Display
Auto Resizing Charts
Fitting Charts to Screen
Customizing Chart Properties
Setting General Chart Properties
Customizing Chart Patterns and Labels
Customizing Chart Colors
Chart Menu Command Reference
Report Designer :
Report Section
Report Section Elements
Report Section Toolbar
Expression Line
Creating a Custom Report
Report Components
Table Column Formatting Options
Inserting Additional Tables in a Custom Report
Adding Report Groups
Inserting Report Headers and Footers
Inserting Page Headers and Footers
Inserting Page Breaks
Adding Other Report Elements
Working with Fields
Modifying Filter Fields
Working with a Report Page
Displaying Rulers
Using Grids
Using Design Guides
Setting Up a Report
Specifying Page Size
Specifying Page Margins
Setting Up Page Columns
Enhancing Report Data
Sorting Report Items
Adding Computed Items
Applying Data Functions
Applying Break Totals
Using True Totals for Computed Items
Hiding and Focusing on Reported Data
Using Multiple Data Sources in a Report
Creating Smart Reports
Formatting Report Items
Converting Detail Reports from Versions Earlier than 6.0
Display Differences
Conversion of Detail Report Categories
Conversion of Data Area
Conversion of Facts
Conversion of Smart Reports
Conversion of Graphic Objects
Report Menu Command Reference
Using Filters :
About Filters
Server versus Local Filter Processing
Filter Line
Filter Controls
Setting Simple Filters
Filtering Queries
Removing a Query Filter
Filtering Results
Removing a Results Filter
Setting Compound Filters
Setting Variable Filters
Customizing Filters Options
Filtering Data in a Table Report
Multiple Filters and the Meta Topic
The Two-Tier Strategy
Filtering Computed Items
Working with Computed Items :
About Computed Items
Computing New Data
Computed Items in Sections
Computed Items and Data Functions
Pivot Options
Adding Computed Items
Operators
Using Functions
Scalar Functions
Teradata Version 3 OLAP Functions
Functions for Returning the Day of the Week
Common Computed Item Examples
Math Functions
Central Tendency
Calculated Averages
Percentile
Rank
Project Sales
Scalar Function Examples
Avg
AvgNonNull
ColMax
ColMin
Count
CountDistinct
CountNull
CountNonNull
Cume
Sum
Median
Mode
Percentile
Rank
RankAsc
StdDev
StdDevp
Var
Varp
Trend Functions
General Moving Average
Positioning of Moving Average Results - Trailing and Centered Averages
Weighted Moving Averages
Exponential Moving Averages
Moving Diff
Moving Maximum
Moving Median
Moving Sum
Moving Minimum
Direction Of Moving Function Calculation
Applying Sorts :
Sorting Data
Simple Sorts
Sort Lines
Complex Sorting
Complex Sorting in the Query, Results, and Table Sections
Complex Sorting in Chart, Pivot, and OLAPQuery Reports