Oracle BI Training

System 9.3, EPM 11 and SQR Training

Oracle BI Interactive Reporting Training
 This course introduces you to the System 9 or EPM 11 Interactive Reporting fuctionality. It focuses on how to use the Hyperion IR development tools to build queries and reports. You will also learn to build BQY documents with Query, Results, Pivot, Chart and Report sections.

    Prerequisites:
  • Relational Database Structure
  • SQL - Preferred

Interactive Reporting Dashboard Development with JavaScript
The Dashboard Development class covers the best practices for developing and deploying dashboards. This course examines the object model in detail, event handlers, Java Script, queries and results, pivots and charts, templates, and tips and tricks.

    Prerequisites:
  • Relational Database Structure
  • Interactive Reporting System 9.3 or EPM 11
  • Object Oriented Scripting Languages

Workspace Administrator - 2 Day Class
Administrator Training covers the administrative duties and tasks associated with administering parts or all of System 9 or EPM 11. Topics include how to administer users, groups, roles, and folders, as well as how to publish reports, schedule jobs, and manage the details associated with the jobs. User support and troubleshooting will also be addressed. A best-practices overview of the repository and associated API's will provide administrators with a greater understanding of what can be customized during the process.

    Prerequisites:
  • Server/Networking Administration
  • Interactive Reporting 9.3

Foundation Installation - 2 Day Class
Installation Training provides a detailed overview and walkthrough of preparing and installing the System 9 or EPM 11 environment. Included in this course will be an overview of the software requirements, installation of Shared Services, connecting with an external Lightweight Directory Access Protocol for user authentication, creation of the repository databases, installation of the web & application servers, installation of the Reporting & Analysis Services & Workspace, and finally installation administration to provide attendees with the necessary knowledge to support the installed applications. Upon completion all members of the class will have the necessary knowledge to fully implement, install, and maintain an Oracle (Hyperion) System 9 environment.

    Prerequisites:
  • Relational Database Structure
  • Lightweight Directory Access Protocol (LDAP)
  • Basic Understanding of Web Servers
  • Basic Understanding of Application Servers

SQR - 3 Day Class
The course focuses on the SQR programming language and its use within the Oracle (Hyperion) Performance Suite. In addition to syntax and coding basics, topics will include the use of advanced query techniques to enhance database performance, customizing reporting with fonts, graphical and customized layouts, and generating HTML output.

    Prerequisites:
  • Relational Database Structure
  • SQL
  • Scripting Langauges