Cognos TM1

Duration : 40 Hrs

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

Name
Email
Review Title
Rating
Review Content
View All Categories

Quick Enquiry

captcha

Technology Portfolio

Loading...