How to improve the performance of a Dynamic Subset?

Posted by Sasidaran MR on December 18, 2017

As a TM1 consultant, one of our challenging tasks is improving performance.

Often dynamic subsets cause memory leakage and in turn affect performance. Let’s discuss, how to convert dynamic subset to static subset with an example.

Read More

Topics: Technical, Business Intelligence, PlanningAnalytics, TM1

How to Implement Parallel Interaction in TM1

Posted by Swetha DC on September 28, 2017

With today's increase in data volumes it is becoming more important to handle the high demand (either loading or accessing) of data conccurrently or in parallel. This blog will assist you by noting the benefits, enabling the functionality, as well as giving you an example.

Read More

Topics: Technical, Business Intelligence, PlanningAnalytics

Thinking about a TM1 upgrade to Planning Analytics, and Planning Analytics Workspace?

Posted by Martin Liwosz on June 25, 2017

IBM is truly living up to its principles of a focus on customer outcomes, restless reinvention, and diverse empowered teams. I believe there is no better reflection of this that IBM’s latest release of Planning analytics (powered by TM1)

No one anticipated that the next iteration would be a such a quantum leap forward. Both in terms of intuitive use, and cutting edge looks; it is refreshing to see IBM invest in this software to bring it ahead of the competition. That’s right I said ahead. To start, with certain installations you will be able to integrate with Watson, that’s right Watson! IBM’s natural language AI, the same AI that helps Doctors in treating cancer patients.

In this blog series I hope to take you on the journey from considering whether you should take the next step, right through to integration with Watson.

Read More

Topics: Technical

Dimension Element Security

Posted by Sasidaran MR on June 25, 2017

Element Security is to set security at dimension element level. Members of the group can access, update, reserve, lock, and delete the element. They can also grant security rights to other users for this object.  Element security will be defined in} ElementSecurity_<DimensionName>.cub. By default element security is set to WRITE access to all the members


Different type of Access Privileges

Admin: Members of the group can access, update, reserve, lock, and delete the element. They can also grant security rights to other users for this object

Lock: Members of the group can view and edit an element and can permanently lock objects to prevent other users from updating them.

Read More

Topics: Technical

TI Debugger Overview

Posted by Ismail Syed on June 25, 2017

The TurboIntegrator Debugger is a simple tool which allows users to set breakpoints and step through TurboIntegrator processes to identify possible issues or errors in your scripts. The TI Debugger is available for Planning Analytics Local.

Steps to configure TM1 Server can be found in the link below:



  • Process List
  • User specified breakpoints
  • View object locks on the TM1 server
  • Save and edit TI scripts live


Read More

Topics: Technical

Config parameters in PA on Cloud - Caveats

Posted by Amin Mohammed on June 25, 2017

As per the IBM’s guidelines, the following points must be taken into considerations pertaining to Planning Analytics on Cloud.

  1. The tm1s.cfg file must exist in the base directory
  2. Any folders that you create must be below the base directory
  3. The location or the name of the base directory cannot be changed
  4. The existing tm1s.cfg file must not be replaced from another server.
Read More

Topics: Technical

Sandbox comparison on Planning Analytics Workspace

Posted by Amin Mohammed on June 25, 2017

Sandbox, also known as Personal Workspace is your personal work area where you can edit the data values as many times as you want and keep the changed data separate from the base data.

Sandboxes and Personal Workspaces are private to each user and cannot be seen by other users. Your data values are viewable to others only when you commit them back to the base data. A Personal Workspace is a special, default sandbox that is unnamed and always where you work if that capability is turned on.


Read More

Topics: Technical

Using Alias in Rule and Feeders

Posted by Amin Mohammed on June 25, 2017

In TM1 rules, an alias could be used in defining the target area (area definition), within rule calculation as well as in Feeders.


However, few things must be kept in mind when using Alias in the Area definition of the cube.

  1. As the rule is now using the attribute value to dictate the rule calculations, it adds a potential risk of inadvertently updating the alias by the users thereby resulting in incorrect calculations. This could be mitigated by applying security on control objects.


Read More

Topics: Technical

Automating testing with TM1 aka Planning Analytics

Posted by Martin Liwosz on June 25, 2017
  • TM1 / Planning Analytics is a robust tool.
  • Typically with other software vendors you need to rely on 3rd Party applications to test. This is not the case with TM1 depending on the type of testing you need done.
  • There are 3 major factors that need to be taken into consideration to define whether you are doing adequate software testing time, cost, and quality.
  • Time and cost is easy to measure but the hardest thing to measure is quality. Especially with manual testing or human testing.
  • In executing the same steps over and over we tend to find short cuts for not doing things the right or long way.
  • There is also an associated cost with manual testing, we are not saying we will or should completely remove the humans but analyse the following below graph
Read More

Topics: Technical

What makes a good TM1 consultant?

Posted by Akshay Rathi on June 25, 2017

The simple answer to what makes a good TM1 consultant is anyone who can do their programming in turbo integrator, write business rules, feeders, and perform an installation of TM1.

Can it really be that simple? If those are the qualities of a consultant then what does it mean to be a TM1 developer? This is where the confusion starts. If the above 

are qualities of a TM1 developer (which is the first stage of becoming a TM1 Consultant) that means we are yet to discover the answer to the question.

Know that the expectation of a consultant is over and above that of developer. So what should you expect of a TM1 consultant? There are several perspectives to look at it. In addition to developer qualities the below qualities are mandatory depending on your perspective.

Read More

Topics: Technical