|
This 2-day course is designed to teach you to connect to different data sources, leverage metadata, create complex queries and reports, and publish and schedule BQY documents on the Web. Exercises help you practice the skills taught.
Oracle PDF Course Description
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
- 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.
|
