IBM TM1, Agentic AI & Finance Transformation Insights

With users unceasingly (almost perennially) demanding higher data upload speed and concurrent transfers, this blog offers insight and considerations one should keep in mind while simultaneously executing a Turbo Integrator (TI) process. It also highlights steps to avoid TI looping and/or thrashing. Synopsys Consider a single user loading data into a cube from source (such as ODBC, Text files, another Cube, etc.) via a TI process for a specific data segment such as a given scenario, period & component, may not experience any wait times. However, when it comes to concurrent users ...

While working for a particular client project, I was asked to review an existing long running Turbo Integrator (TI) process and find out ways to optimise its processing time, without compromising on the business functionality. Synopsis: A process was created to adjust the amount between cost centres and products based on defined From and To mapping in a mapping cube. A simple example could be, amount from one cost centre be adjusted to multiple centres within its division or a consolidation of centre within a division mapped to same consolidation but for a different product. To achieve this, ...

In this blog, would like to introduce you to a new feature called "Compare Sandboxes"; this feature, an extension to Planning Analytics Workspace’s existing capability, shall be available both on Cloud and in Local versions. What is a Sandbox? (Jump to “Feature Explained” section if you are an existing TM1 user & know this well) A Sandbox lets you create your own personal workspace, your own version where you can enter & store data-value-changes without impacting the base (actual) data. A sandbox is not a copy of the base data, but a separate overlay or a layer of your own data values ...

The last 3 weeks has been great in that it has showed an avenue that I had yet to explore in Planning Analytics, debugging. To say it has been highly frustrating at times is an understatement, however I know I only get stressed when I’m learning a difficult concept. It sometimes hard when looking at code that isn't' documented, exactly why this or that piece of code is necessary. Debugging work has benefited me in understanding and developing a methodology to enable me to learn the overall logic and flow of a model/system. Understanding and being able to follow personalised instead of best ...

If you haven't seen already the latest version of Cognos Analytics is now available for you to download. Luckily you won't need to read the about the latest changes. You can view this youtube clip which will explain what's new in it's reporting, dashboarding, stories and the portal for IBM Cognos Analytics 11.0.11. If you don't have the time some advanced features include using custom polygons and points for mapping. Also included is data caching in dashboards and stories, as well as support for Portal Pages, and controlling object visibility. To download the software you can find the ...

Let me preface this blog by saying that my trip to India was so insightful, culturally rich and filled with great people that it was hands down the work trip of a life time. Amendra may have had other plans but for me this trip was about creating new connections and deepening my understanding of our cross border colleagues from all our offices. Upon reflection I can easily say that we weren't colleagues for very long and are now people I consider friends. Well some of them, in-particular those who didn't want to Shoot me?! I still don't know where the finger guns came from but I suspect thats ...

Most who are still on Cognos Business Intelligence software version 10.2.x would know that the software version was due End of Service this April 2018. It was quite dreading for existing users who had not planned an upgrade to Cognos Analytics (or C11 as it is called within IBM) just yet as it wasn’t really a straight forward version upgrade but a complete overhaul in the way you would interact with Cognos BI; more intuitive, user friendly and insightful but requires a bit of learning and a little more unlearning. GOOD NEWS!! IBM has just announced a new support option – Continuing Support ...

In this blog, let me explain you about one of the hidden/unused feature from IBM Cognos TM1. Before we start, let me ask you a question - Have you ever come across below requirements or related issues while working with TM1? Urgent requirement - Management needs new consolidation within a Canned report to meet their business needs. An Ad hoc requirement from business to get new consolidation member at the earliest. An alternative roll-up request from the Boss - for a better analysis using existing data. Stakeholders request to have additional consolidations which may be part of ad hoc ...

For starters, God's algorithm is a notion originating in discussions of ways to solve the Rubik's Cube puzzle, but which can also be applied to other combinatorial puzzles and mathematical games. It refers to any algorithm which produces a solution having the fewest possible moves, the idea being that an omniscient being would know an optimal step from any given configuration (source wiki). With the constant barrage of messaging these days, almost pushing you over to adopt cloud, does the choice between “To Move” or “Not To” almost feel like cracking the “God’s Algorithm”? Well, hopefully by ...

This blog will cover an information regarding moving the data between cubes using Rules and Feeders. Questions to be asked before we get started with the topic... Why do we need to move the data to another cube which is having similar dimension structure….?? Can’t we just modify the existing cube….?? Answers “we can modify the cube” and “there is no need to create a duplicate cube “, although there can be a few exceptions like dependent cube(s) which might have been used to create report which sometimes a client may request not to modify. Ideally the data can be moved between cubes using TI ...

One of the major challenges of promoting code to successive instances is packaging the code for promotion and finding a slot for downtime. Not to mention the sequence of steps required to carry out the procedures and to communicate to one and all about the impending downtime. Adding to this difficulty is finding downtime when users are accessing the application from across the globe.So irrespective of deployment size, either major or minor, the deployment process is never going to be easy. However you can potentially overcome this using one of the TM1 Suite tools. To achieve this the ...

In this weeks blog, our team make it our duty to shine some light on right tool your company can choose to meet your business needs. We will cover the much discussed benefits of installing and using IBM's Planning Analytics workspace on Windows 2016. Contents What is PA and PAW PAW and Windows 2016 Benefits on PAW on Windows 2016 What is PA and PAW? Planning Analytics ("PA") is the next version, or can be considered as the next generation of TM1. IBM enhanced TM1 functionality and features and embraced new tools to its' suite. This new enhanced TM1 has been rebranded as PA. IBMs PA has the ...