Cognos TM1
Overview:
IBM Cognos TM1 is the enterprise planning application software is used to transform your entire planning cycle like collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. It gives immediate visibility into data, accountability within a collaborative process, and a consistent view of information, allowing managers to quickly stabilize operational fluctuations and taking the advantage of new opportunities.
Training Objectives of Cognos TM1:
Cognos TM1 enables planners and analysts to uncover hidden business options, increase profits and manage capital effectively. It provides an on-demand approach to consolidating, viewing, and editing enormous volumes of multidimensional data. Our Expert Online Trainers will explain you all concepts based on the Real Time Scenario’s.
Target Students / Prerequisites:
Students must have basic knowledge on OLAP and TM1 and Significant experience with Excel spreadsheets (functions, macros, etc.) and Understanding of the metrics and drivers of your business.
Examine TM1 Components
- Review financial performance management
- Identify the TM1 user community
- Describe the components of TM1
Browse Data in a Cube
- List the components of a cube
- Create a new view of the data
- Stack, swap and filter dimensions in a cube
- Use drill capabilities to focus the data
Focus Your Analysis using Subsets
- Examine the benefits of subsets
- Use aliases in subsets
- Filter subsets
- Differentiate between static subsets and dynamic subsets
Contribute Data
- Spread data to multiple cells at once
- Edit individual cells
- Exclude cells from being adjusted
Work with Spreadsheets
- Differentiate between a slice and a snapshot
- Use a classic slice and an Active Form
- Manage TM1 data through Excel
Work with Spreadsheets
- Create interactive reports and data input templates using Active Forms
- Customize Active Forms using new TM1 Functions
- Apply formatting to Active Forms
Create Dynamic Reports with Active Forms
- Create interactive reports and data input templates using Active Forms
- Customize Active Forms using new TM1 Functions
- Apply formatting to Active Forms
Configure a TM1 server
- Define a TM1 server
- Create a configuration file
- Identify the basic tasks required to create a TM1 application and deploy it
Create Dimensions
- Review cubes and dimensions
- Create dimensions manually
- Create dimensions using Turbo Integrator
Build Cubes and Views
- Discuss cubes and data points
- Create cubes
- Construct views of data in cubes
Load and Maintain Data
- Identify data sources
- Create processes to load data
- Create a process to delete data in a cube
- Create processes to update and maintain the model
Add Business Rules
- Discuss a rule
- Construct rules for elements or consolidations
- Use functions in rules
- Optimize rule performance
Automate Common Processes Using Scripts
- Review Advanced tabs in Turbo Integrator
- Load custom data into a cube
- Add a subset to a dimension
- Use logic in scripts
- Export data to ASCII
- Move data between versions
- Construct chores
Customize Drill Paths
- View related data
- Create a Drill Process
- Create a Drill Assignment Rule
- Edit a drill process
Manage the Server
- Broadcast messages to clients
- Connect and disconnect users from a TM1 server
- Shut down a remote TM1 server
Implement TM1 Security
- Identify TM1 authentication options
- Create users and groups
- Assign object security rights to groups
Integrate with IBM Cognos 8 BI
- Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment
- Integrate IBM Cognos TM1 in Cognos 8 BI portals