IBM TM1, Agentic AI & Finance Transformation Insights

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

Config parameters in PA on Cloud - Caveats

Comment_Icon_black0
Alarm_Icon_12 min

As per the IBM’s guidelines, the following points must be taken into considerations pertaining to Planning Analytics on Cloud. The tm1s.cfg file must exist in the base directory Any folders that you create must be below the base directory The location or the name of the base directory cannot be changed The existing tm1s.cfg file must not be replaced from another server. Link: https://www.ibm.com/support/knowledgecenter/SSD29G_1.0.0/com.ibm.swg.ba.cognos.tm1_cloud_mg.10.3.0.doc/c_tm1_cloud_faq.html In addition to the above, the following config parameters in tm1s.cfg file must not be modified ...

Line_2015

Sandbox comparison on Planning Analytics Workspace

Comment_Icon_black0
Alarm_Icon_15 min

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. To find out more about Sandbox, go the following link: ...

Line_2015