|
This 2-day course is designed to teach you to connect to different data sources, leverage metadata, create complex queries and reports, customize the Hyperion Intelligence Dashboard Builder template, and publish and schedule BQY documents on the Web. Exercises help you practice the skills taught.
In this class, students will learn:
- Creating Connection Files
- Connection File Overview
- Creating Basic Connection Files
- Setting Advanced Options
- Displaying Metadata
- Creating Data Models
- Star Schema Design Principals Overview
- Adding Topics to the Content Pane
- Joining Topic Items
- Modifying Topic and Item Displays
- Setting Query Governors
- Creating Meta Topics
- * Creating Master Data Models
- Synchronizing Data Models with the Database
- Creating Complex Queries
- Creating Local Joins
- Creating Limit Local Joins
- Combining Queries with Query Operators
- Creating Subqueries
- Creating Correlated Subqueries
- Creating Derived Tables
- Processing Results to a Database Table
- Exporting, Importing, and Customizing SQL
- Creating Complex Reports
- Defining Drill Paths
- Displaying Multiple Results in a Free-Form Report
- Creating Complex Computed Items
- Examining the Hyperion Intelligence Object Model
- Script Editor and Object Browser in Hyperion Intelligence Designer
- Distinguishing Elements in the Object Model
- Addressing Objects, Properties, and Methods
- Viewing and Modifying Object Properties
- Testing and Debugging Code
- Creating and Upgrading Dashboard Templates
- Distinguishing BQY Document Types
- Distinguishing Sections in the Dashboard Template
- Creating Dashboard Templates
- Upgrading Templates
- Creating Dashboard Template Frame Prototypes
- Key elements of Frame Prototypes
- Creating Frame Prototypes
- Modifying the Behavior of a Template Toolbar Button
- Object Events Overview
- Modifying OnActivate Events
- Modifying User Events
- Replacing the Default Text of Language and Tooltip Strings
- Replacing Language Strings
- Replacing Tooltip Strings
- Publishing and Scheduling BQY Documents on the Web
- Web Modules in Hyperion Foundation
- Publishing Process Overview
- Publishing Connection Files, BQY Documents, and BQY Jobs
- Running and Scheduling BQY Jobs
- Managing BQY Jobs in the Job Manager Module
Several lab exercises are provided throughout both days to reinforce comprehension and retention of the material.
Prerequisites:
Completion of the Hyperion Intelligence Tools: Design Reports and Dashboard course or equivalent knowledge of the subject matter. Working knowledge of JavaScript and SQL Knowledge of data warehouse design principles.
|
