Training Outline
TM1 End user (1 day)
·
Concepts
o OLAP
Explained
o Advantages
of TM1
o Architecture
·
Getting Started
o Starting
TM1 Client/Perspectives
o Accessing
TM1 Servers
o Server
Explorer View
·
Browsing Data
o Cube
Viewing
o Data
perspective
·
Working with Subsets
o Managing
lists of elements
o Selecting
( filtering) elements
o Saving
Element Selections
o Editing
Element Selections
o Expanding
Consolidation Elements
o User
Defined Consolidations
o User
Defined consolidations on the Fly
o Dynamic
Subsets
·
Cube Views
o Working
with cube views
o Filtering
cube views
o Entering
Data in Cube View
o Write
back Modes and Sandboxes
·
Using TM1 with Excel
o Snapshot
o Slice
o Excel
Database link formula
o Changing
Excel worksheet
o Changing
cell values
o Writing
and Editing TM1 formulas
o Report
Tips
·
Creating Reports
o TM1
Report Wizard
·
Organizing TM1 Objects
o Applications
·
Entering Data
o Manual
data input
o Data
Spreading
·
Active Forms
TM1
Developer (2 days)
·
Concepts
·
Multidimensionality
·
Creating
Cubes and Dimensions
- Cube Design
- Type of Elements
- Element Attributes
- Dimension Element
considerations
- Dimension Editor
- Dimension Worksheets
- Advantages of Dimension
Worksheets
- Turbo Integrator
- Cube Creation
- Importing Data
- Cube Viewer / Excel Worksheet
Slices
- DBSW Send Formulas
- Excel Process Worksheets
- Turbo Integrator
- Load Errors
- Rules ( Calculations)
- Overview of Cube rules
- Rule Worksheets
- Rules Editor
- Rules Syntax
- Common Examples
- Skipcheck and Feeders
- Feeder Guidelines
- Checking and Troubleshooting
Rules
- Order of Rules
- Organizing Applications
- Overview of TM1 Applications
- Creating and Managing
- Adding Files to Applications
- Updating Excel Files on
Server
- Updating Non-Excel Files on
Server
- Security
- TM1 Pick Lists
TM1
Turbo Integrator (1 day)
·
Concepts
- What is Turbo Integrator
- Data sources
- Import options
- Saving metadata and data
- Functions
- Processes and chores
- Who can use Turbo Integrator
·
Creating
a process
- Creating a dimension from an
ASCII file
- Loading a dimension from a
table
- Loading a cube and its
dimensions
- Creating Chores
- Creating a chore
- Editing a chore
- Activating a chore
- Deactivating a chore
- Executing a chore
- Using Drill-Through
- Drilling to a relational
table
- Drilling to a view
- Drilling from consolidated
elements
- Using parameters
- Using the TM1 Action Button
- Overview
- Adding an Action button to a
worksheet
- Configuring an Action button
- Setting the appearance
properties of the Action button.
- Finishing the Action button
and returning to your worksheet.
- Specifying the process and
parameters
- Configuring options
- Static, dynamic and
conditional pick-lists
TM1
Administrator (1 day)
·
Setting up the physical server
- Collecting server information
- Creating server folders
- Granting access to server
folders
- Installing TM1
- Validating the TM1
installation
- Understanding the Client
Server Architecture
- Accessing a local TM1 Server
- Accessing a remote TM1 Server
- Resolving connectivity issues
- Understanding remote server
operations
- Logging Transactions
- Enable and disable
- Viewing
- Backing out records from the
transaction log
- Removing log files from the
disk
- Reviewing error logs.
- Backing up a TM1 Server
- Managing client connections
- Understanding Remote server
operations
- Replication overview
- Why replicate
- What gets replicated
- Replication considerations
- Relationships created by
replication
- Key points
- Typical server configurations
- Required access privileges
- Maintaining replication
connections
- Creating a replication
connection
- Modifying a replication
connection
- Deleting a replication
connection
- Replication process
- Advanced replication options
- What happens when TM1
replicates a cube
- Synchronization process
- Authentication
- ETLDAP
- Modifying LDAP attributes
- Running ETLDAP
- Configuring the LDAP login
parameters
- Building an LDAP query
- Connecting to the TM1 Server
- Mapping LDAP attributes to
TM1 fields
- Exporting LDAP information to
TM1
- Synchronizing TM1 data with
ETLDAP
- Integrated login
- LDAP authentication
- Maintaining Users and Groups
- TM1 users and groups overview
- Administrators
- Adding and deleting users and
groups
- Defining users
- Defining groups
- Assigning users to groups
- Setting and clearing
passwords
- Setting an expiration for a
user
- Controlling group access to
TM1 objects
- Assigning security rights to
groups
- Interaction of difference
object security rights
- Securing cubes
- Securing dimensions
- Securing elements
- Securing cells
- Securing processes
- Securing chores
- Securing applications and references
- System performance and
monitoring
- Admin server log
- Server message log
- Monitoring server performance
- TM1 Top
- Performance counters
TM1 Executive Viewer (1 day)
·
Introduction
o
Connection
·
Folders
& Views
o
Overview
of Folders & Views
·
Basic
Member Selection
o
Member
Selection
·
Basic
Navigation
o
Navigation
Overview
·
Advanced
Member Selection
o
Finding
Members
·
Advanced
Navigation
o
Advanced
Navigation Overview
·
Data
Selection
o
Data
Selection Overview
·
Suppress
missing, No Access and Zero
o
How
to Suppress
·
Charts
o
Charts
Overview
·
Calculations
o
Calculations
Overview
·
Formatting
o
Introduction
·
Traffic
Lights
o
Traffic
Lights Overview
·
Printing
o
Printing
Overview
·
DynaSelect
o
DynaSelect
Introduction
·
Data
Entry
o
Data
Entry Introduction
·
Audit
Report
o
Audit
Report Overview
·
Global
Settings
o
Global
Settings Overview