IBM TM1, Agentic AI & Finance Transformation Insights

What's in a name? Watson in the name!

Comment_Icon_black0
Alarm_Icon_12 min

Starting 1 April 2021, "with Watson" will be added to the name of the IBM Planning Analytics solution. IBM® Planning Analytics with Watson will be the official product name represented on the IBM website, in the product login and documentation, as well as in marketing collateral. However, IBM TM1® text will be maintained in descriptions of planning analytics' capabilities, differentiators and benefits. What is the "Watson" in Planning Analytics with Watson? The cognitive help feature within Planning Analytics with Watson is the help system used in IBM Planning Analytics Workspace (Cloud). ...

Line_2015

Planning Analytics Audit log – Little known pitfall

Comment_Icon_black0
Alarm_Icon_12 min

The blogs brief about the challenge faced post enabling the Audit log in one of our client's environment. Once the audit log was turned on to capture the metadata changes, the Data Directory backup scheduled process started to fail. After some investigation, I found the cause was the temp file (i.e., tm1rawstore. ) generated by the audit log by default and placed in the data directory. The Temp file is used by audit log to record the events before moving it to a permanent file (i.e., tm1auditstore). Sometimes, you may even notice dimension related files (i.e., DimensionName.dim.), and these ...

Line_2015

Worried about Data Spreading in Consolidations? Here’s how.

Comment_Icon_black0
Alarm_Icon_13 min

IBM Planning Analytics provides the functionality of Data Spreading at Consolidations to users for faster planning and analysis in TM1 Architect, TM1 Perspectives, IBM PAW and TM1 Web. You can evenly distribute a value across a range of cells or increment all values in a range of cells by a percentage. The problem comes in when there are a greater number of users involved in Data Entry, and if the Dimensions in the Cube have more elements and intersections. For instance, if multiple users perform Data Spreading at the consolidated level at the same time, this slows down the overall ...

Line_2015

Merging multiple Dynamic Reports in PAfE using Power Query

Comment_Icon_black0
Alarm_Icon_13 min

Ever wondered how good it would have been to merge multiple dynamic reports next to each other for doing your analysis from disparate reports, only to be realise that it can’t be possible? Fortunately, Power Query is here to our rescue and that’s what we will be looking at in this blog post. So, to start with, what is Power Query? Power Query, also known as Get & Transform in Excel 2016, is an Excel interface that finds data from wide range of data sources and performs data transformations using its ETL processing editor called Power Query Editor. Power Query then creates queries and ...

Line_2015

Dynamic Arrays and Its Impact on Planning Analytics for Excel

Comment_Icon_black0
Alarm_Icon_12 min

In my previous blog articles, I have covered various use cases of Dynamic Arrays(DA) and some of the capabilities it offers. In case you missed it, I would strongly recommend you go through them (see links below) before proceeding with reading this blog. What are Dynamic Array formulas and why you should use them Data Analysis using Dynamic Array formulas In continuation of that, I will cover another use case where I would further highlight the power of DA when used with PAfE. With that being said, ever since I learnt about Dynamic Arrays in Excel, I was very fascinated and always wondered ...

Line_2015

TM1 Rest API: Dimensions Metadata Extract

Comment_Icon_black0
Alarm_Icon_14 min

The Blog shows how to use TM1 Rest API to extract, filter, select only specific details/properties from the dimensions, all the metadata extracted from TM1 Rest API will be in JSON. If this is your first time on TM1 Rest API, then it is recommended to visit the link below which covers the introduction and helps with getting started on TM1 Rest API. https://blog.octanesolutions.com.au/introduction-to-tm1-rest-api Here, we will be using Go_New_Store TM1 Sample Instance in windows environment and Chrome Browser with JSONView Extension https://:/api/v1/ AdminHost: The Server name where the Admin ...

Line_2015

Backup and Restoration PAW- Dashboards, Workbooks and views

Comment_Icon_black0
Alarm_Icon_111 min

With the recent update from TM1 to Planning Analytics, IBM has introduced PAW (Planning Analytics Workspace) which can be utilized to Develop Dashboard, Reports, Graphs, Workbooks, Views etc., as per any individual’s Requirements. But if these Workbooks and Views are accidently deleted, then it will be impossible to restore them unless you have a backup of those objects. Also, IBM does not take backups of these Books and Views developed in PAW. Hence its necessary for us to have a backup procedure and Restore them if required. To perform this backup and Restore activity, make sure you have ...

Line_2015

Biggest release since 2015 - Planning Analytics Workspace 2.0.57

Comment_Icon_black0
Alarm_Icon_16 min

The much awaited major release of Workspace is out now. The new version Planning Analytics Workspace 2.0.57 is available for download for on premise installs. Cloud version will follow in Mid October. Planning Analytics Workspace was released on 11th December 2015. This new look and feel and the features like workflow, AI forecasting, the rich visualisations and virtual dimensions + the features TM1 was born with - the write back, On the fly Consolidations and excel integration will now take TM1 to the next level... TM1 is putting the final nail in the coffin for its competitors! Here is a ...

Line_2015

Data Analysis using Dynamic Array formulas

Comment_Icon_black0
Alarm_Icon_16 min

How to create reports using dynamic array formulas in Planning Analytics TM1 In our previous blog (https://blog.octanesolutions.com.au/what-are-dynamic-array-formulas-and-why-you-should-use-them), we discussed about Dynamic Array formulas and highlighted the key reasons and advantages to start using DA formulas. In this blog, we will try to create a few intuitive reports based on custom reports built on PAfE. The data set we will be using is shows the employee details in “Employee” cube with the following dimensionality: Dimension Measure Year Department Version Name/Desc Sr.No Current Salary ...

Line_2015

Dynamic Array formulas in IBM PA TM1 - Supercharge your Excel report

Comment_Icon_black1
Alarm_Icon_14 min

What are Dynamic Array formulas and why you should use them? In this blog article (and few other upcoming blogs), I am going to write about the capabilities of Dynamic Array (DA) functions with examples and demonstrate to you some great features it has that I believe can empower the PA Analysts to do all differently sorts of data analysis in a simpler and much more intuitive way, thereby enhancing their productivity. To start off, lets first understand what Dynamic Array functions actually are? To put it simply, the DA functions are those functions that leverages Excel’s latest DA calculation ...

Line_2015

Octane Celebrates 4th Anniversary

Comment_Icon_black0
Alarm_Icon_16 min

2020 has been an interesting year for us ! Celebrations This month Octane celebrates our 4th anniversary. Never imagined that we would be celebrating with our team members across different geographies via online gifts and Teams meetings. Normally we fly in all our team members to one location for the weekend and have a great time bonding. However with the global pandemic we had to adapt as the rest of the world is. The journey so far On the whole, reflecting back on the journey so far on our anniversary 2020 certainly has thrown in an riveting challenge. Having started from a small shared ...

Line_2015

Session Timeout for TM1Web, PAW and PAX

Comment_Icon_black0
Alarm_Icon_13 min

We might often get a request from users that TM1 session has logged. As per the client requirement and standards, need to increase or decrease the session timeout. Changing the session timeout is a trade-off, it should not be too big or too small. If it’s too big then many inactive sessions can lead to server performance issues. If it is too small, then the user experience might be affected. Each application of TM1 has its separate session timeout parameter. Jump into the respective section, depending upon your need. TM1Web 1. Go to \IBM\cognos\tm1_64\webapps\tm1web\WEB-INF\configuration and ...

Line_2015