IBM TM1, Agentic AI & Finance Transformation Insights

Although we as devlopers solve problems and that gives us a feeling of success and empowerment, I landed on the realisation that by documenting a problem not just jumping in and fixing it; helps make better decisions. Ok now some of you might ask How did you get there? Others might say well yes of course. I'd like to think that it’s not for any of the obvious reasons you might think of. Let's see. Not all problems will provide a eureka moment but a couple, even one on a particular subject can lead to the formulation of a business transformation initiative. Yes it's happened and while my heart ...

How to utilize TM1 Planning Analytics functionality for your Technology Allocations Allocation Technology and other Service charges back to the departments is typically a difficult exercise for most organisations. There is a large amount of different data sources , data mapping, calculations and reporting capability required. This is just for the actuals – forecasting accurately is usually a bridge too far for most organisations. It does not have to be this difficult! Why do we need to allocate charges – It largely influences the behavior and ensures that departments incur appropriate level ...

As the CFO of your company, your organisation relies on you for more than just numbers. Yes, spreadsheets and financial reports are the hallmarks of your profession. But what about business intelligence and forecasting? Today, the explosion of data available in business matches the explosion of competition in today’s markets and CFOs need to harness that wealth of data to compete. CFOs need better business intelligence tools to identify upcoming opportunities and grab them before their competitor does. They also need to foresee potential losses and advise on how to mitigate risk. In short, ...

IBM Cognos TM1 supported by Planning Analytics is the ideal technology for making Excel-centric budgeting, forecasting, financial reporting and any spreadsheet-based analytical application scale to the enterprise. IBM's TM1 for Microsoft Excel brings the power and familiarity of Excel to the arena of modern enterprise performance management. Planning Analytics, on the other hand, enables business and financial analysts, line-of-business managers and others to explore and analyse data from a variety of different sources—including IBM Cognos TM1 and IBM Cognos Business Intelligence—without IT ...

Is your organisation not realising the full potential of your IBM TM1 implementation? A quick and easy way to increase your productivity, reduce cost and risk is to ensure your users are properly trained in your TM1 model. The best deployed TM1 models can have limited engagement and usefulness if your users are not using it properly TM1 models are built ground up and almost always unique to the organisation so a stock TM1 training usually does not help. 4 Key features of a effective TM1 training delivery Training is tailored to the needs of your users - Almost all TM1 models are unique to ...

In this article is not about being a master and his trusted advisor, this is about trying to find out what are the necessary traits for a successful consultant. I'll be comparing the ideas of 'Master of one' Vs 'Jack of All' Vs 'Master of All'. Let's start from the last one 'Master of All' and with a bit of self reflection, do you really think it is possible for anyone to be a master of everything? I am not quite a believer of this, although, theoretically it is possible but practically in the ever changing world it is impossible to master all the technologies because human psychology says ...

Often times, when we as a developer are loading the data from a particular source and intend to create a view to debug the data for analysis and troubleshooting, typically we do it by creating the view and subsets and assigning the subsets to the view in Prolog tab. The elements from the source are then added to the subset in data tab by using SubsetElementInsert function. This will work seamlessly as long as there is only one record for one element in the source. As soon as the TI encounters multiple records of each element, it starts to add that element again in the subset resulting in ...

By default a numeric value in TM1 is 0. If an attempt is made to store a zero in a cell of the cube, that storage request is ignored. If we input 0 for an intersection, TM1 treat it as NO value instead of 0 value. Instead we can use the UNDEFVALS function. This is to be defined in the Rules file which will enable the end user to input 0 value. Scenario Let’s create a simple cube with 3 dimensions Cube Name: Test Dimension: Actvsbud Region Month Fill up dummy values in cube for the intersection, Actual, all the months and United States Region Open Rule file for Test Cube and type UNDEFVALS; ...

It's hard in our industry particularily when when starting to guage how good you are or how much you know in relation to the products, especially when you don't get to mix and mingle with other Planning Analytics or TM1 developers. Worse is that you don't get to see / hear about other implementations / environments. The aim with this blog is to feature every so often different things you can do to keep work feeling fresh, help, and to push you in different directions. You don't necessarily know how good you are if you're not covering off the basics. So lets start there. Step 1: Can it be done ...

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. Let's start with the what parallel interaction / concurrency is and it benefits: It's a IBM server feature allowing concurrent operations (read/write). The concurrency operations can be performed on the same cube object. Writing to a cube will not lock it. This means that it will not wait for readers using the same cube to ...

I have been closely following and writing about trends in the business intelligence market over the past three years. During this time, I can’t say that we’ve seen any “radically new” trends, and I don’t expect any to emerge in the second half of 2017. What I have seen, so far in 2017, is the “evolution” of the dominant trends driving a dynamic BI market. The global business intelligence market is expected to reach USD 26.50 billion by 2021, growing at a CAGR of around 8.4% between 2016 and 2021 (Zion Market Research). Here are the 5 BI trends predicted to most influence the BI market in 2017 ...

This may be the most cost effective and scalable method to take your TM1 application to the next level. There are many reasons why outsourcing your TM1 support and development could be the right solution for your organisation: - Access to highly skilled TM1 developers on demand in a cost effective way - Models built a couple of years ago haven't evolved with the business - Lack of ownership within the organisation - Shortage of skilled TM1 specialists capable of managing the application In today's blog, we would like to list and discuss the five key benefits of outsourcing your TM1 support ...