Loading Course Schedule...
PT10347
Training Summary
This one-day course is designed to teach analysts and developers how to create advanced queries and reports. In addition, creating connection files to data sources and data modeling are included. Instruction can be provided using either Hyperion Interactive Reporting Studio or Web Client. We will utilize course manuals and resources that have been specifically designed for the version you are using.
Prerequisites
Prior to taking this class, students should have:Completion of the Designing Queries & Reports course or equivalent knowledge of the subject matterBasic knowledge of SQLGeneral knowledge of database and data warehouse design principles
Duration
1 Day/Lecture & Lab
Audience
This course is ideal for business analysts, report developers, and administrators.
Course Topics
- Create advanced queries such as subqueries, local joins and append queries
- Develop complex reports including combining data from multiple results in band-style reports
- Build computed items to meet special reporting needs
- Design data models including Meta Topic views
- Establish connectivity to data sources
- Implement quality document design practices