Cognos TM1 – 10

Homepage
>
Courses Offered
>
Product
>
Cognos TM1 – 10

Duration : 30 Hrs

Download

IBM Cognos TM1 (formerly Applix TM1, formerly Sinper TM/1) is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the “leaf” level. Computations on the leaf data are performed in real-time (for example, to aggregate numbers up a dimensional hierarchy). IBM Cognos TM1 includes a data orchestration environment for accessing external data and systems, as well as capabilities designed for common business planning and budgeting requirements (e.g. workflow, top-down adjustments).

TM1 Components

Tm1 architect
Tm1 perspectives
Tm1 turbo integrator
Tm1 Cube Viewer
Tm1 Subset Editor

How to Create New TM1 server and configure Server

Cognos Performance Modeler

About Performance Modeler
Types of Dimension in Performance Modeler
How to create Dimensions manually
How to Create Measure Dimension
How to Create Time Dimension
How to Populate Time Dimension
How to Create Hierarchy Dimension
How to Add Attribute to Dimension
How to Create Pick List
How to Create Dimension using process
How to create Calculated Column
How to Create Cube
How to load data into Cube
How to Link Cubes
Types of access permissions in Performance Modeler
Levels of access permissions in Performance Modeler
How to provide access permissions in Performance Modeler
How to Create Users and User Groups in Performance Modeler
How to add users to User Groups in Performance Modeler
How to assign capabilities to user Groups
Types of Applications in Performance Modeler
How to create application in Performance Modeler
How to validate application
How to publish application
How to provide Rights to application
How to Import Rights
How to Export Application
How to Import Application

Cognos Insight

About Cognos Insight
How to Create Model Using Dreage and drop
How to create Model Using XL as Data source
How to TM1 As data source
How to User Database As Data Source
How to create Calculate columns
How to edit data in Insight for Tm1 Cubes
How to Create Custom Groups
How to export Data into Ex
How to add Exported XL into Tm1 Applications
How to update in insight and export into Excel
How to create applications
How to Publish application
How to activate application
How use action button in Insight

Create Elements

Types of Elements
Simple
String
Consolidated
Creation of elements
Editing Elements
Adding alias attributes to elements
Using alias attribute in Cube viewer

Creation of Dimension

Creation of dimension manually
Creation of dimension using TI process
Creation of dimension using Dimension worksheet
Creating dimension using CSV as Data source
Creating dimension using Database as Data source
Creating dimension using subset as data source
creating more then one dimension from one data source
creating Alias attributes using Alias process
adding alias attribute for existing dimension using TI process

Creation of Cube manually

Creating of Cube using TI process

Loading data into Cube

Updating data in Cube

Creation of Subset

Creation Of Subset
How to create public subset
How to create private subset
How to create default subset
How to create dynamic subset
Use Subset in Cube

Creation of Cube View

Private View
Public View
Default View

Creation Of filter

Filter by Level
Filter by Wildcard
Filter by attribute
Data Filter Creation

Working with Sandboxes

Creation of sandboxes
Deleting sandboxes
Commit Sandboxes
Reset data

Work with Spreadsheets

Creation of Slice
Creation of snapshot
Creation of Active from
Active from vs snapshot
snapshot vs slice
How to create inspreadsheet browser
How to create More then one inspreadsheet browser and compare Data
How to Create Subset from inspreadsheet browser
How to create Cube View from inspreadsheet browser
How to restrict Write access for worksheet in Tm1 Web

How to create Template

How to Run Process using template
How to pass value from XL to Process

Working with Worksheet Slice and active form

Adding Action Buttons in worksheet

In Spreadsheet Browser

How to Create In Spreadsheet Browser
How to swap row and columns

Worksheet Functions

DBR
DBRW
SUBNM
VIEW

Create Slice report Using Function

Pick List

How to create Static Pick List
How to create Subset Pick List
How to create Dimension Pick List

WORKSHEET CONTROLS

Data Validation

FORMAT AND PRINT RESULTS

How to print report in single work book
How to print report in multiple work books

Drill Through

Drill through to cube view
Drill through to Data Source(using ODBC)

Adding Business Rules

Writing business Rules

Controlling calculations

Adding business logic to rules

Data Spreading and hold values

MANAGE THE SERVER

BROADCAST MESSAGES TO CLIENTS
DISCONNECT CLIENTS FROM THE TM1 SERVER
SHUT DOWN REMOTE TM1 SERVERS

REPLICATE AND SYNCHRONIZE SERVERS

Replicate Cubes: Overview
Replicate Cubes: Advantages
Remove Replications
Synchronization
Schedule synchronization
Delete Replicate

About Log

ADMIN SERVER LOG
TRANSACTION LOG
SERVER MESSAGE LOG
AUDIT LOG

Deleting data in cube

Integrate with IBM Cognos 10 BI

Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment
Integrate IBM Cognos TM1 in Cognos 8 BI portal
Importing Cognos Tm1 Cube into Cognos 8 Bi Environment

TM1 WEB

About TM1 Web
Components in TM1 Web
How to create Cube view in TM1 web
How to use subset in Tm1 web
How to create Chart Report
How to change Chart Type and Colors
How to Change Chart appearance
How to Change Chart Properties
How to Run Process in Cognos TM1 Web
How to Edit Chores
How to Activate Chores
How to Execute Chores
How to change user password
How to change Dimension Properties
How to create Sandbox
How to commit Sand box
How to reload sandbox
How to delete sandbox

How to integrate TM1 Web with Cognos BI Portal

Tm1 Security

Manually adding users to Server
Adding users to user groups using TI process
Creation of groups
Apply Security to cubes
Apply security to Dimensions
Apply security to Elements
cell level security
Locking Objects
Reserve objects

Tm1 operations console

About operations console

How to add Server to operations console

Partial List Of Courses Offered At Our Organization

Abinitio
Android
AIX Administration
Business Analyst
CCNA, CCNP Security, CCIE
Citrix XenApp
Cognos 10 BI & Tm1
Crystal Reports
Data Stage
DB2 DBA
Dot Net
DAC
Google Web Tool Kit
Golden Gate
Hadoop
HTML 5
IBM Websphere Commerce server Admin
IBM Lotus Notes (Development)
IBM Lotus Notes Domino Server Administration
IBM Message Broker
IBM MQ Series
IBM Tivoli Access Manager
IBM Web Sphere Application Server Administration (WAS)
IBM WAS Portal server Development
IBM Websphere Transformation extender (WTX 8.2)
Informatica
I Phone
Java/J2EE
J Query
Java Apache Wicket
MCITP
MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
Microstrategy
MicroSoft Business Intelligence
OBIEE 11 g
ODI ( Oracle Data Integrator)
Oracle ATG
Oracle APPS – HRMS
Oracle APPS – SCM
Oracle APPS - Manufacturing
Oracle APPS – Financial
Oracle APPS – Technical
Oracle APPS – Project Accounting
Oracle BI Apps
Oracle BI Publisher
Oracle DBA 11g
Oracle RAC , Data Guard , Performance Tuning,
Oracle Fusion SOA
Oracle SQL , PL SQL
People Soft
PHP
Perl Scripting
Qlikview
RUBY Cucumber
SAP SD , BO , FICO , BI / BW , APO , BPC, BASIS , SRM , MM, ISOil
SAS
Sales Force CRM
SharePoint Server 2010
Shell Scripting
Siebel CRM , EAI, E-Scripting
SQL Server DBA
Springs and Hibernate
Storage Area Network ( SAN)
Tableau
Tera Data
Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB, RFT
TIBCO BW, BE, TIBCO I Process
Tivoli Access Manager & Identity Manager
Unix Administration
VMWare
WCF, WPF, LINQ, AJAX, SILVER LIGHT
Webservices , SOAP , REST ( JAVA)
Windows 2012 server

Reviews

No reviews

Post Review

View All Categories

Name
Email
Review Title
Rating
Review Content