Our TM1 training courses are only delivered by our own experienced
consultants. Their real world experience and expertise allow
them to focus not only on the mechanics of TM1 technology,
but also on designing/implementing complete solutions, integration
with other technologies, and improving application acceptance.
The range of courses provided ensures that there is always
the right course for each member of your team whether they
require basic concepts, implementation fundamentals, or advanced
techniques.
We also offer bespoke training courses in addition to our
standard set, ideal for those organizations looking to achieve
the highest levels of knowledge transfer in the shortest possible
time.
All courses can be run either on-site or at our Didsbury
(Manchester) site. The maximum number of delegates for each
course is usually six unless otherwise stated.
This hands-on course will address Dimension and Cube Building,
Rules, Advanced Worksheet Functions and Report Automation,
and creating ad-hoc import worksheets. On the first day of
this course attendees will learn the basics of writing TM1
Rules and how and when to apply them. The second day will
introduce attendees to some of the more advanced TM1 and
Excel worksheet functions that can be used for building automated
and interactive reports for analysis, planning, budgeting,
and forecasting and how to import data from a flat file or
cube using import worksheets.
Outline
- Dimension Building and Maintenance
- Creating New Cubes
- Fundamentals of Rules
- Recommended Formatting of Rules
- Introduction to Asynchronous Inter-Cube Rules
- Using Rule Functions
- Relative Rules
- Introduction to Skipcheck and Feeders
- Using Advanced TM1/Excel Functions
- Building String Cubes
- Importing and Exporting Data
- Processing Data Between Cubes
- Introduction to Turbo Integrator
- Complex Processing Spreadsheets
- Defining Attributes and Aliases
Prerequisites: The End User Course and working knowledge
of Windows and MS Excel
Course length: 2 days
This hands on course covers advanced rules concepts - currency
conversions, allocations, detailed feeders & memory usage.
Upon completion, attendees will be able to create powerful
analytic and business modelling calculations and improve the
efficiency and maintainability of TM1 rules.
Outline
- Refresher on Rules
- Simple One Cube Rule
- Inter-Cube Rules and Indirect References
- Linking Cubes with Differing Dimensions
- Foundation in Skipcheck and Feeders
- Linking Cubes with Different Levels
- Time Based Calculations
- Allocation (Break Down) by Proportion
- Opening Balances and Depletions over Time
Prerequisites: End User Training and Developer Training and
working knowledge of Windows and MS Excel
Course length: 2 days
|