IBM TM1, Agentic AI & Finance Transformation Insights

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

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://www.ibm.com/docs/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_enabletidebugging.html 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 ...

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

Automating testing with TM1 aka Planning Analytics

Comment_Icon_black0
Alarm_Icon_12 min

TM1 / Planning Analytics is a robust tool. Typically with other software vendors you need to rely on 3rd Party applications to test. This is not the case with TM1 depending on the type of testing you need done. There are 3 major factors that need to be taken into consideration to define whether you are doing adequate software testing time, cost, and quality. Time and cost is easy to measure but the hardest thing to measure is quality. Especially with manual testing or human testing. In executing the same steps over and over we tend to find short cuts for not doing things the right or long ...

Line_2015

The Octane Difference

Comment_Icon_black0
Alarm_Icon_12 min

Choosing or even switching consulting companies is never an easy choice. Sometimes competitors make that easy be ruining relationships but being the newest on the scene also comes with inherent challenges. Although we have the best in the business, and we are landing new large clients being the latest player in the market is hard. Especially with customers who think all consultants provide the same. At times Price seems to be the only way a customer tries to tell us apart but what’s on offer is always VERY different. So here we are doing something else different, let us tell you about the ...

Line_2015

What makes a good TM1 consultant?

Comment_Icon_black0
Alarm_Icon_12 min

The simple answer to what makes a good TM1 consultant is anyone who can do their programming in turbo integrator, write business rules, feeders, and perform an installation of TM1. Can it really be that simple? If those are the qualities of a consultant then what does it mean to be a TM1 developer? This is where the confusion starts. If the above are qualities of a TM1 developer (which is the first stage of becoming a TM1 Consultant) that means we are yet to discover the answer to the question. Know that the expectation of a consultant is over and above that of developer. So what should you ...

Line_2015

Planning Analytics Virtual Dimensions through TI Process

Comment_Icon_black0
Alarm_Icon_16 min

Background Virtual Dimensions will change the game of Analysis with Planning Analytics (Powered By TM1) You can use Product, Customer or Employee Attributes in your slice/dice/pivot tools as ‘Virtual Dimensions’ without having to physically define them as a dimension when creating the cube You can add virtual dimension at any time after the cube exists, so your analysis opportunities are endless Cubes can now be half the size and twice as fast bec ause you don’t need physical dimensions to drive analysis And further, you can add fresh new data to your analysis ‘On the Fly’ with no disruption ...

Line_2015