Hyperion Advanced Reporting Class Overview

Learn To:

• Create connection files for documents
• Design data models for users
• Address complex reporting issues

Course Objectives:

• Configure connection files for data sources and metadata
• Create and administer data models
• Design advanced queries and reports  

Course Topics:

Creating Connection Files

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

Creating Data Models

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

• Defining Drill Paths
• Creating Complex Computed Items