Cognos TM1 Course Content
Introduction to Cognos TM1
Understanding multi-dimensional OLAP database, TM1 Web, TM1 Executive Viewer, TM1 Servers and Services, Cognos TM1 Installation.
Cognos TM1 Configuration
Managing the components and tasks – start, stop and add TM1 Servers, use the components – TM1 Web, Applications and Operations Console, create or delete Windows/Desktop services using Command prompt.
Manual creation of Dimensions, Sparse and Dense Dimensions, reviewing Cubes and Dimensions, using Turbo Integrator ETL, deploying Dimension Editor/Attributes, working with various elements.
Building Cubes and Views
learning to create New Cube View, using View Builder Wizard, understanding Cube and data Points, deploying Cubes for constructing Data Views, View types – Private, Public & Default, Dynamic and Static Subset creation.
Working with TM1 Turbo Integrator
Understanding the ETL process in Turbo Integrator, extract data from multiple sources, loading data into TM1 Cubes, creating processes for data loading and deleting, scheduling and editing processes through procedures – Data, Metadata, Prolog, Epilog, identifying and mapping variables.
Cognos TM1 Rules
Understanding TM1 rules, TM1 Rules Editor, rules compilation, using functions, rule performance optimization, working with Feeders and Skipcheck.
Advanced Scripting with Turbo Integrator
Working with Advanced tab of Turbo Integrator, creating scripts for editing procedures, deploying Dimension subsets and attributes.
TM1 Data Spreading
Distributing numeric data across cells in Cube View, data spreading functions, procedures and methods, drill-through process and rules for assigned detailed data to cells.
Advanced Modeling Techniques
Significance of advanced modeling, manually adding objects to application design, understanding application views, dimensions and hierarchy, virtual cubes, lookup cubes, spread profile cube.
The various security levels including Server level, Cube level, Dimension level.
TM1 Application Web
Importance of Application Web for extreme formatting, working with TM1 Application Web.
Cognos TM1 Project
Project – Create and Deploy Planning Applications to the Prospects (Excel)Data – SalesTopics – This project is involved with exploring and analyzing data that is derived from Cognos TM1 models into the Excel spreadsheet format. Learn how to move data between Cognos TM1 model and Excel while retaining the Excel functionality, extending the analytics capabilities for faster and better decision-making. You will closely work on connecting TM1 Server with Excel, creating Slicer and Snapshot, creating and managing active forms. Upon completion of the project you will know how to build powerful multi query and multi sheet reports against different databases.