IBM TM1, Agentic AI & Finance Transformation Insights

Take complexity out of Excel and systemize data with IBM Cognos TM1

Comment_Icon_black0
Alarm_Icon_12 min

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 ...

Line_2015

Increase your TM1 engagement with end User Training

Comment_Icon_black1
Alarm_Icon_12 min

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 ...

Line_2015

Being a Consultant: Master vs Jack of all trades

Comment_Icon_black0
Alarm_Icon_12 min

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 ...

Line_2015

Removing the ‘bug’ from Debugging in TM1

Comment_Icon_black0
Alarm_Icon_14 min

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 ...

Line_2015

It's important to know how to handle null values in TM1

Comment_Icon_black1
Alarm_Icon_13 min

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; ...

Line_2015

A how to be a better developer

Comment_Icon_black0
Alarm_Icon_12 min

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 ...

Line_2015

How to Implement Parallel Interaction in TM1

Comment_Icon_black0
Alarm_Icon_14 min

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 ...

Line_2015

The Most Influential BI Trends in 2017

Comment_Icon_black0
Alarm_Icon_15 min

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 ...

Line_2015

Have You Considered Outsourcing Your TM1 Support? Great!

Comment_Icon_black0
Alarm_Icon_14 min

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 ...

Line_2015

TM1 upgrade to Planning Analytics, and Planning Analytics Workspace

Comment_Icon_black0
Alarm_Icon_13 min

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! ...

Line_2015

Dimension Element Security

Comment_Icon_black0
Alarm_Icon_13 min

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_.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 ...

Line_2015

TI Debugger Overview

Comment_Icon_black0
Alarm_Icon_15 min

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: https://developer.ibm.com/recipes/tutorials/ibm-tm1-turbointegrator-debugger/ KEY FEATURES Process List User specified breakpoints View object locks on the TM1 server Save and edit TI scripts live INTERFACE The interface is very simple and user friendly with familiar tabs like Prolog, Metadata, ...

Line_2015