IBM TM1, Agentic AI & Finance Transformation Insights

Planning Analytics with Watson (TM1) Training made easy

Comment_Icon_black1
Alarm_Icon_14 min

We have made it easier for your users to access Planning Analytics with Watson (TM1) Training. This week we launched our online training for Planning Analytics with Watson PAW and PAX; available online in instructor-led, 4-hour sessions. Planning Analytics with Watson (TM1) Training This training provides the ideal time for you to spend some of your allocated training budgets; often assigned but never utilised on something that you can actually apply in your workplace. We have made it easy for you to book your training online in a few easy steps. IBM has been consistently improving and adding ...

Line_2015

8 reasons to switch to TM1 Planning Analytics

Comment_Icon_black0
Alarm_Icon_12 min

Have all the data but not the full picture ? Business Intelligence is not a software application but rather concept of accelerating and improving decision making; optimizing internal business processes; increasing operational efficiency; driving new revenues; and gaining competitive advantages over business rivals. BI systems should help companies identify market trends and spot business problems that need to be addressed. It encompasses displaying historical data as well as new data as its generated from source systems enabling analysis to support both tactical and strategic decision making ...

Line_2015

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