Lesson 1: Introduction to Cognos TM1
o Understanding multi-dimensional OLAP database
o TM1 Web
o TM1 Executive Viewer
o TM1 Servers and Services
o Cognos TM1 Installation.
Lesson 2: Cognos TM1 Configuration
o Managing the components and tasks – start
o stop and add TM1 Servers
o use the components – TM1 Web
o Applications and Operations Console
o create or delete Windows/Desktop services using Command prompt.
Lesson 3: Creating Dimensions
o Manual creation of Dimensions
o Sparse and Dense Dimensions
o reviewing Cubes and Dimensions
o using Turbo Integrator ETL
o deploying Dimension Editor/Attributes
o working with various elements.
Lesson4: Building Cubes and Views
o learning to create New Cube View
o using View Builder Wizard
o understanding Cube and data Points
o deploying Cubes for constructing Data Views
o View types – Private, Public & Default
o Dynamic and Static Subset creation.
Lesson 5: Working with TM1 Turbo Integrator
o Understanding the ETL process in Turbo Integrator
o extract data from multiple sources
o loading data into TM1 Cubes
o creating processes for data loading and deleting
o scheduling and editing processes through procedures – Data, Metadata, Prolog, Epilog
o identifying and mapping variables.
Lesson 6: Cognos TM1 Rules
o Understanding TM1 rules
o TM1 Rules Editor
o rules compilation, using functions
o rule performance optimization
o working with Feeders and Skipcheck.
Lesson 7: Advanced Scripting with Turbo Integrator
o Working with Advanced tab of Turbo Integrator
o creating scripts for editing procedures
o deploying Dimension subsets and attributes.
Lesson 8: TM1 Data Spreading
o Distributing numeric data across cells in Cube View
o data spreading functions
o procedures and methods
o drill-through process and rules for assigned detailed data to cells.
Lesson 9: Advanced Modeling Techniques
o Significance of advanced modeling, manually adding objects to application design
o understanding application views
o dimensions and hierarchy, virtual cubes, lookup cubes
o spread profile cube.
Lesson 10: TM1 Security
o The various security levels including Server level, Cube level, Dimension level.
Lesson 11: TM1 Application Web
o Importance of Application Web for extreme formatting
o working with TM1 Application Web.