Get news from our subject-matter experts

If you are comparing TM1 and Power BI, you are asking the wrong question. These are not competing products. They solve fundamentally different problems. TM1 is a planning engine, and Power BI is a visualisation platform. Comparing them is like comparing an engine to a dashboard: one produces the power, and the other displays the information. The real question is: when do you use each, and how do you connect them? The Core Difference in One Sentence TM1 writes data. Power BI reads data. That is the entire architectural divide in eight words. IBM Planning Analytics (TM1) is a database where ...

In my previous blog articles, I have covered various use cases of Dynamic Arrays(DA) and some of the capabilities it offers. In case you missed it, I would strongly recommend you go through them (see links below) before proceeding with reading this blog. What are Dynamic Array formulas and why you should use them Data Analysis using Dynamic Array formulas In continuation of that, I will cover another use case where I would further highlight the power of DA when used with PAfE. With that being said, ever since I learnt about Dynamic Arrays in Excel, I was very fascinated and always wondered ...