|
Duration: 1 Day
Audience: Experienced
Impromptu Users Brief:
The course is geared to Impromptu users
who want to enhance their skills to handle
more complex reporting requirements by exploiting
the full potential of Impromptu’s advanced
features. Attendees will learn how to customize
their environment, set standards, create
drill-through and sub-reports and build
templates. In addition, workshops will provide
techniques to enhance presentations, build
complex calculations and automate procedures.
Course Notes:
This course can be delivered using an Impromptu
demo database, or upon request your instructor
will utilize your own database and catalogs
as the basis for the workshops, examples,
and class discussion. There is an additional
fee for customization.
Recommended Prerequisites:
Introduction to Impromptu or equivalent
experience (several months working with
Impromptu – ability to add data, filter,
sort, group, format and add calculations
is assumed).
|
Topics:
Setting up the Impromptu Environment
• Customizing
Impromptu
• The startup
process
• Defaults
and preferences
Optimization
• Using Hot
files and Smart Hot files
• Modifying
data access
Presentation
• Frame-based
reporting
• Types of
frames and their uses
• Frame properties
and formatting
• Conditional
formatting
Analyzing Data
• Filters
and conditions including summary
filters
• Functions
• Date techniques
• Smart summaries
Sub-Reports
• Use sub
reports with multiple queries to
create
complex reports
Drill Through Reports
• Link summary
reports to detail reports using
drill through technique
Advanced Prompt Usage
• Cascading
prompts and various Pick list styles
Improving Performance
• Analyzing
SQL
• Making the
most of the database engine
Templates
• Using templates
• Adding advanced
features to templates
Integrating and Automating
• Understanding
OLE
• Importing
and exporting
• Integrating
with other Windows applications
including PowerPlay
• Creating
macros
• Using the
IBM Cognos Scheduler
|
|