ibm impromptu - administration

By attending Impromptu - Administration workshop, delegates will learn to:

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

The IBM Impromptu - Administration Training course is 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, Participants learn to design and build an Impromptu application for a sample user group within an organization. The course takes them through the planning process, from identifying your users, their data requirements, and the available data, to the actual creation of the application in Impromptu.

Impromptu - Administration 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 AGENDA

  • 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
  • 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
  • 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
  • Define a join
  • Discuss different join strategies
  • Discuss different join types
  • Create and use and alias table
  • Analyze joins
  • Resolve join exceptions
  • Test joins
  • Modify folder definitions
  • Create calculations, conditions, and prompts within the catalog
  • 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
  • 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