Audience
This course will benefit all those involved in business planning using IBM's Cognos Planning Analyst.
Prerequisites
There are no prerequisites for this course.
Duration
3 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
Through in-depth lecture presentations and extensive practical exercises, delegates learn to construct, implement and maintain business planning solutions utilising Cognos Planning Analyst.
At the end of this three day course, delegates will have a practical understanding of how to build and maintain Analyst models using best practice techniques.
Course Content
Basic Modeling
The role of Analyst in the IBM Cognos Planning system.
Identify the basic building blocks and objects used by Analyst.
Principles of Model Design.
Creating simple D-Lists.
Building input and calculation D-Cubes.
Linking data using D-Links.
Intermediate Modeling
Different method of importing data.
Formatting D-Lists and D-Cubes.
More Complex D-Links.
Maintaining D-Lists.
Automating model updates with macros.
Advanced Modeling Techniques
Output D-Cubes and consolidation D-Links.
Maintaining D-Cubes.
Data modelling with conditional calculations and D-Cube allocations.
Using ODBC to import data.
Using Built in Functions (Bifs).
Administration and Maintenance
Setting up users and groups.
Applying library security.
Maintaining objects with the library functionality.
Copying and moving objects.
Building Manager Flowcharts and Menus
The role of Manager in a planning application.
Using the flowchart function.
Building menu screens.
Automating applications with menus.
Excel Add-in and Manager Reports
Overview of the Excel Add-in for Analyst.
Creating basic reports.
Reports with multiple views.
Printing Reports.
Manager Reports.