Download PDF
of this course

Impromptu Administration (Z3302G)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Course Duration 2 days.
Impromptu Administration - Series 7 Version 3 and 4 - Impromptu Administration is a two-day, self paced course designed to provide new Impromptu administrators with the skills they need to plan, implement, deploy, and maintain an Impromptu application for users with a variety of reporting requirements. Following a typical application development project lifecycle, you'll learn how to design and build an Impromptu application for a sample user group within an organization. The course takes you through the planning process, from identifying your users, their data requirements, and the available data, to the actual creation of the application in Impromptu.

Who Should Attend

This course is intended for:
  • Administrators who will be responsible for creating and managing Impromptu catalogs.
  • Experienced Impromptu users who want to upgrade their Impromptu skills to include administrative capabilities.

Course Certifications

This course is part of the following Certifications:


You should have:
  • Impromptu Series 7.x Report Building
  • Thorough working knowledge of both Impromptu and Windows
  • Understanding of database design and Structured Query Language (SQL) (recommended)

Course Objectives

  • Please refer to the course overview for description information.

Course Content

Getting Started
  • Describe your role as the Impromptu Administrator
  • Review what Impromptu is and how it benefits both users and administrators
  • Describe the different components of Impromptu
  • Discuss how Impromptu fits into the Cognos Business Intelligence Software suite
  • Recognize the need to know your users and your data
  • Understand the Impromptu application planning process and Project Life Cycle
  • Analyze user requirements for data access
  • Identify data sources and examine ways to connect Impromptu to the data
  • Identify the data, including required data that does not exist in the database
  • Examine table joins and folder definitions
The Database and the Catalog
  • Discuss the relationship between the catalog and the database
  • Discuss the benefits of the catalog
  • Create a catalog definition
  • Add tables
  • Work with default folders
  • Create a Content Overview report
Working with Joins
  • Define a join
  • Discuss different join strategies
  • Discuss different join types
  • Create and use and alias table
  • Analyze joins
  • Resolve join exceptions
  • Test joins
Working with Folders
  • Modify folder definitions
  • Create calculations, conditions, and prompts within the catalog
User Profiles
  • Describe what user classes are and why they are used
  • Create user classes and user profiles
  • Define table and folder access for user classes
  • Apply filters to user classes
  • Use Governors to control access to data, the catalog, and reports
  • See how catalog types define default user profiles
  • Discover the benefits of making a catalog Distributed
  • Balance work between the client and the server
  • Change the order in which tables are retrieved
  • Identify weighting options
  • Describe Governor options
  • Work with alternative data sources
  • Discuss the use of Stored Procedures
  • Discuss query access options
User-Defined Functions
  • Distinguish between the two types of User-Defined Functions (UDFs)
  • Recognize the various .INI and .SQL files that affect UDFs
  • Modify the .INI files and .SQL files to add support for new UDFs
  • Customize the user environment
  • Schedule reports
  • Plan the move from development to production
  • Study the catalog maintenance cycle
  • Identify the possible conflicts in database vs. catalog definitions
  • Learn how to resolve the possible conflicts

Course ID: Z3302G

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register