IBM TM1, Agentic AI & Finance Transformation Insights

IBM Planning Analytics review against key software quality attributes

Comment_Icon_black0
Alarm_Icon_18 min

While reading the excerpts from various books and journals on science direct website, I couldn't help but start thinking of how IBM PA fares against these quality attributes of software, which has precisely led me to write this blog article hoping to share my thoughts with you. As I do this, I am also hoping that this will aid the CFOs and other decision-makers in choosing the right software for their organization based on these key traits. Before we start talking about software quality attributes also known as SQA, let us first understand what it takes to assess the quality of any software. ...

Line_2015

Celebrating Five Fabulous Years for Octane Software Solutions

Comment_Icon_black0
Alarm_Icon_18 min

It’s an amazing feeling as we gear up to celebrate Octane’s 5th anniversary. What started as an idea and nurtured by me and my senior leaders is fast transforming into an established and growing enterprise. Five years is usually a significant milestone in a startup’s life as it pushes you into a grown-up zone. It’s been an exciting journey and the pandemic indeed threw some curveballs at us. From Macquarie to Octane I am often asked about the motivation to resign from Macquarie Group to start Octane. Macquarie was an excellent learning ground to nurture one’s entrepreneurial fire. I found a ...

Line_2015

Octane Software Solution Partner With QUBEdocs to Deliver Cutting Edge

Comment_Icon_black0
Alarm_Icon_13 min

Octane Software Solutions is a cutting edge technology and services provider to the Office of Finance. Octane is partnered with vendors like IBM and BlackLine to provide AI-based solutions to help finance teams automate their processes and increase their ability to provide business value to the enterprise. Qubedocs is an automated IBM Planning Analytics documenter. It generates automated documentation within minutes and ensures compliance and knowledge management within your organisation. So, we're excited to announce our partnership with QUBEdocs - a solution that takes the resources and ...

Line_2015

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