Course Overview

The IBM Clarity: Building Templates and Reports (V6.2) (MSAS) course is a hands-on instructor-led course that provides Administrators, Project Implementers, and Template and Report Developers with knowledge on how to build and maintain data entry templates and reports for financial budgeting, reporting, and data analysis purposes.

Who Should Attend

  • This intermediate course is for Administrators, Project Implementers, and Template and Report Developers.

Course Certifications

This course is part of the following Certifications:


  • Knowledge of Microsoft Excel and Excel formulas
  • Experience with financial/accounting principals

Course Objectives

Please refer to Course Overview for description information.

Course Content

Introduction to OLAP
  • Understanding OLAP and OLAP Database Concepts
Introduction to IBM Clarity
  • Using Templates and Reports
  • Using Toolbox Commands for Data Entry and Reporting
  • Using Relational Input Templates
  • Understanding the Template and Report Building Process
Building IBM Clarity OLAP Templates and Reports
  • Using the Template and Report Builder Application
  • Creating OLAP Templates and Report
  • Integrating Additional Features to Templates and Reports
Building IBM Clarity Relational Templates and Reports
  • Understanding Relational Database Concepts
  • Creating Relational Templates and Reports
  • Creating Hybrid Relational and OLAP Templates
Using IBM Clarity Security Services
  • Managing Users, Roles and Menu Items
  • Creating and Managing Hierarchy Security
  • Managing Clarity Administration Features