Course Content

This instructor-led series of workshops teaches the key points of modelling your data in Framework Manager. In this intensive day through hands-on workshops, attendees will learn how to use best practice when building packages over star-schema data. Starting with the basics of navigating your way around Framework Manager it moves on to show how to model your data relationally and dimensionally. The latter workshops cover differing ways of handling security in your packages.

Course Modules

  • Workshop 1: Identify Components and Reporting Objects in Framework Manager
  • Workshop 2: Create a project (star schema data).
  • Workshop 3: Change query item properties, add modelling layer and relationships (star schema data).
  • Workshop 4: Customise metadata at run time: Create calculations.
  • Workshop 5: Adding alias tables (bringing one table in more than once).
  • Workshop 6: Add an extra fact table with a different level of granularity (to show how determinants can fix).
  • Workshop 7: Create a relational presentation layer.
  • Workshop 8: Create a dimensional layer.
  • Workshop 9: Specify package access in Framework Manager.
  • Workshop 10: Specify object security.
  • Workshop 11: Row level security.

“A wonderful course the trainer was amazing at answering any queries.She was extremely helpful and I would definitely recommend it.”

Priyanka Patel
Student Systems Development Office, University of Sussex

Who should attend?

This is an intermediate course which is intended for developers who want to design metadata models.

Knowledge of common industry standard data structures and design.

Prerequisites

Knowledge of common industry standard data structures and design.

Duration

One day

Location

Simpson Associates Customer Centre/ Customer Location

Cost*

£1300

*Cost is for a course held at your site with a maximum of 6 delegates and includes a set of preconfigured laptops for the duration of the training and manuals for each delegate

Download Resource
Nick Evans
Do you have a question? Call 01904 234 510 or Email Nick
Simpson Associates IBM Training

Principles of TM1 Performance Modeler

  • DURATION: 2 Days
  • LOCATION: Simpson Associates Customer Center or Customer Location
  • COST: £3000
Further Details