IBM TM1, Agentic AI & Finance Transformation Insights

In this article we will quickly go through the steps required to make your excel calculation mode defaulted to ‘Manual’. When working on websheets, it is advisable to keep the calculation mode to Manual to prevent repeated recalculation of formulas for any cell change when the calculation mode is Automatic. The default calculation mode could be set to Manual by following the below steps: Step 1: Close all excel workbooks and open a new workbook. Step 2: Change the Excel calculation mode to Manual (File - Options - Formulas) Step 3: Save the workbook in ...

You heard it right – Is your organisation still on TM1 10.2.X and haven’t upgraded to PA? If yes, this is the blog for you as your existing TM1 application is prone to Multiple Security Vulnerabilities … Blog tries to reflect upon the cause and effect of the issue/s, possible interim remediation plan/s and the foolproof solution. Security Vulnerabilities Customers who are still using the IBM Cognos TM1 10.2 and IBM Cognos TM1 10.2.2 are prone to unauthenticated attacks, excessive stack memory issues and other threats. Listed below are the security Vulnerabilities; OpenSSL could allow a remote ...

Thank you if you have come back for more! Hope our last blogs of this series Unravelling TM1 : Lesser Known Facets – Part A & Part B were meaningful. In this part we will unearth & explore few more of these lesser known gems. As always, if you like what we do and want to associate; subscribe to our Blogs at http://blog.octanesolutions.com.au TIP 7: Uses of User-Defined Global Variables User-Defined Global Variables declared within a TI using functions StringGlobalVariable (for string variables) and NumericGlobalVariable (for numeric variables) though rarely used and meant for specific ...

Business trip to Australia… the prospect itself is enough to make a dead man stand up and dance. More so as Swetha, Sasi & I were travelling to be in 2 of the worlds “best cities to live in. We visited Perth & Sydney; No..no 3 cities in fact, we transited via Melbourne airport. I know what you thinking, but it does count as we got to “check-in” Facebook... Haha, see SMART!! Before I start, very important to note the itinerary we were on as it boosted our flaunt status back in India! Why ?? Well it had so many check points and an envious schedule which had us touching 4 countries & ...

This Tuesday (25th Sep 2018) Octane Solutions proudly hosted a meeting for Senior Finance, IT Executives and Experts representing various companies and industries. The event was kicked-of by Mr. Amendra Pratap (MD, Octane Solutions) and Mr. Thomas Maddocks (ANZ Software Sales Leader - Commercial, IBM). This was followed by a solution demonstration conducted by Mr. Kevin Jessop (Lead FPM Solution Specialist, IBM) and a panel discussion. Thank you to all who attended our Executive Breakfast event; We were pleasantly overwhelmed with the response and excitement in the room. Redefining Planning ...

Thank you if you have come back for more! Hope our last blog Unraveling TM1 : Lesser Known Facets – Part A was meaningful. In this part we will unearth & explore few more of these lesser known gems. As always, if you like what we do and want to associate; subscribe to our Blogs at http://blog.octanesolutions.com.au Function TM1RPTROW We know TM1RPTROW is a salient function when building demand and rolling forecasts in Planning and Budgeting models Although everyone is aware of the fact that parameters like Dimension Subset, MDX Expressions are a part of TM1RPTROW, developers tend to ...

No matter how much we think we know about TM1, there are always these set of conditions that make you think “what-if there was a better way”??!! For example, not having to write a bunch of codes just to delete the subsets after using it in a Source View Or not writing the same area definition twice. What-if this could be done with less or no coding at all! This blog and its subsequent part will focus on showcasing few of such many lesser known features in TM1. These little tricks and tips are a step towards better code management and of course peace of mind. TIP 1. One area definition for two ...

Welcome back, for those who had read Part A of this blog, hope you would have tested Parallel Interaction and benefitted from it. For those who haven’t, you can read it at http://blog.octanesolutions.com.au/caveat-around-concurrent-data-loads-part-a This blog builds upon the previous one and focusses on improving performance by Parallel Interaction, it highlights TM1 facets worth consideration while an object is locking. Synopsys Tips towards improvements around support for concurrent read/write and/or parallel execution of turbo integrator process enabling higher efficiencies and ...

IBM has recently launched its Planning Analytics version 2.0.5 (on 25th June 2018); this article captures highlights of what’s new, improved and denounced. New / Improved/ Deprecated Features & Fixes: - New: Planning Analytics Administration agent. Totally new, part of IBM’s strategy to brand PAW as a Single interface for all types of users. In this release, once PAA agent has been configured, it enhances Planning Analytics Workspace user’s interaction with metadata and data. Helps users to drag and drop dimension members to achieve new Dimensions, Attributes. Users can drag and drop ...

I want to keep this blog very simple so that people who do not know the concept of blockchain can understand it. Target audience – anyone who can read English. What is a Blockchain? In very simple terms blockchain is a chain of blocks where a block means data. A more sophisticated definition was given by Don & Alex Tapscott, authors Blockchain Revolution (2016): "Blockchain is an incorruptible digital ledger of economic transactions that can be programmed to record not just financial transactions but virtually everything of value." Most of you might think, there we go again, why another ...

One of the most neglected and least prioritised activity among the grand scheme of development, in my opinion, is applying correct formats to data, both in cubes as well as standard web reports. In all fairness, if you’re one of my kind (occasionally-fall-into-a-slack type) who often miss out on this detail, then you have arrived at the right place. In my defence, I still feel that given the number of data points that one must apply formatting, it is only natural to miss a few, which then gets picked by business in live environment. Well, this blog is all about how you save yourself from such ...

In TM1, if a TM1 Cube has huge of volume of data and rule calculation, there is possibility that TM1 takes longer time to open a cube view, to look at the issue with performance would be TM1 View Caches (Stargate Views). The Stargate view contains only the data for a defined section of a cube and does not contain the formatting information and browser settings that are in a view object. The purpose of a Stargate view is to allow quicker access to the cube data. To fine tune and control the Stargate Views, TM1 provides couple of settings namely VMM (View Maximum Memory) and VMT (View Minimum ...