Course description: Series 7 Version 3 and 4 - Impromptu Administration SPVC

PLEASE DO NOT MAKE TRAVEL ARRANGEMENT FOR THIS SELF PACED VIRTUAL COURSE (SPVC). ONCE YOU ARE ENROLLED IN THIS COURSE, YOU WILL NOT BE ABLE TO CANCEL YOUR ENROLLMENT.

After you receive confirmation that you are enrolled, you will be sent further instructions to access your course material and remote labs. You will then have a 30 day window in which to complete your course. Within this 30 days, you will have 336 hours of elab time. The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day, but lab system access is allocated on a first-come, first-served basis. When you are not using the elab system, ensure that you suspend your elab to maximize your hours available to use the elab system. Once you have accessed the course, help is available Monday through Friday; questions will be responded to within 24 hours.

NO EXTENSIONS FOR THIS COURSE WILL BE GRANTED.

This is the self paced training version of ""Series 7 Version 3 and 4 - Impromptu Administration"" classroom course. 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.

View this course in other countries

Back to top

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.

Back to top

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)

Back to top

Please refer to Course Overview for description information.

Back to top

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

Planning

• 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

Performance

• 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

Deployment

• Customize the user environment
• Schedule reports
• Plan the move from development to production

Maintenance

• Study the catalog maintenance cycle
• Identify the possible conflicts in database vs. catalog definitions
• Learn how to resolve the possible conflicts

Back to top

Minimum Requirements (for PC) to use SPVC

• Windows 2000, XP, Vista, and 7
• Firefox, including V3.6.6
• Internet Explorer, including V8
• browser settings include:
• Java Runtime Environment must be installed and enabled in the web browser
• Web browser must be set to enable/allow JavaScript
• Web browser Pop-up blocking mechanisms must be set to allow pop-ups from elearn.ihost.com
• Cookies must be enabled
• Flash-enabled
• CITRIX, for the remote lab (instructions to install included with the SPVC)

Back to top