Who is it for
Developers
Duration
8 hours
Difficulty
Advanced
Product
IBM Planning Analytics Workspace or Perspectives
Next Course
Advanced TurboIntegratorAdvanced Rules
This course is a deep dive into writing Rules, a formula-driven language that applies business logic to Cubes. By the end of this course, you will gain more confidence in writing arithmetic formulas to formulas with multi-cube logic. You will also learn why the TM1 Server is appreciated for its ability to handle data sparsity and how to manage this powerful feature. Here is a breakdown of thelessons covered in this course:
- 1. The fundamentals for writing Rules
- 2. How to use logic operators
- 3. How to feed to and from consolidations
- 4. How to write a formula requiring data from other Cubes
- 5. How to write a currency translation rule
- 6. How to write a moving balance rule
- 7. How to polish the TI process for productionHow to use handle data sparsity
Interested in learning this course? Choose the enrolment option that suits you
| Single Course | Power User Membership | Enterprise Membership | |
| Training Course | Choose the course(s) to enrol in, from our library of ten courses | Upskill your knowledge with access to ALL of our available courses | Using our training framework, training content and expertise, build your own bespoke course that matches your environment. |
| Training Course Access | Receive 12 months of training course updates and post-training insights, continuing your knowledge on the subject | Receive 12 months of training course updates and post-training insights, continuing your knowledge on the subject | Ensure your staff’s upskilling can be achieved seamlessly |
| Training Server Access | 10 hours per course * Excluding Introduction to IBM Planning Analytics | 10 hours per course * Excluding Introduction to IBM Planning Analytics | Your content will be stored on our secure training platform, trusted by leading software companies worldwide. |
| Training Options | Choose one of these options: – Self-Paced – Online Classroom (schedule) | Choose one of these options: – Self-Paced – Online Classroom (schedule)* * Excluding Slice, Apliqo UX and Apliqo UPM | Lock in regular training sessions with our consultants throughout the year. |
| Digital badge | Achieve a digital badge that endorses the knowledge learnt for the course undertaken | Achieve a digital badge that endorses the knowledge learnt for the course undertaken | Achieve a digital badge that endorses the knowledge learnt for the course undertaken |
| Community Hub | Stay up to date with the latest news dedicated to IBM Planning Analytics | Stay up to date with the latest news dedicated to IBM Planning Analytics | Stay up to date with the latest news dedicated to IBM Planning Analytics |
| Video Hub | Not included | Access to hundreds of presentations with tips from consultants, models built by customers and insights from IBM | Choose to include |
| Horizon, Global User Conference | Not included | Full access to all presentations for this coming event | Choose to include |