Here we present a fully worked example of how to create element level security for an organisation that requires complete lockdown for entire branches of a dimension. It uses element level security down to the N level, applied via a TI.
The MONTH function in TM1 allows us to extract the number representing the Month from a date. Here we explain it’s syntax and give an example combining it with the DATE function.
Here is a really easy method for checking if an Attribute Exists in TM1 via Turbo Integrator process. It essentially does what an “AttributeExists” or an “AttrExists” function would do for you if they existed in TM1.
The Date Function in TM1 converts a serial date from a number to a string. For example Date(13947 , 1); will return the string ‘1998-03-09’.
TM1 and Excel can now share the same serial date system by the use of UseExcelSerialDate=T in your tm1s.cfg file. Here is the details on this development in Planning Analytics. This means that day number 1 is 1-Jan-1900 in both systems.
Use Active Forms to create dynamic list reports in Excel using TM1 data, that can be zero suppressed and allow users to expand and contract hierarchies.
How to set the order of elements in a dimension in TM1, either manually via the Dimension Editor, automatically via TM1 Server Explorer or within a Turbo Integrator process – and why you should be very careful when using it!
Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.
What are the options for TM1 training? Who are the providers for training in TM1? Do I have to sit in classrooms? Is there virtual training available for TM1? Can I get TM1 coaching? All these questions are answered in this explanation of how the TM1 training market works.
How to install IBM Planning Analytics for Excel (PAX) or Cognos Analysis for Excel (CAFE) onto a client computer and connect to an IBM Cloud version of Planning Analytics (TM1).