PAW Tip: Statistical visualization using BOX Plot What is it? Box plots have been around in PAW since version 2.0.63. The purpose of this visualization is to help the financial analysts to view the concentration or distribution of their financial data at a glance, including the summarized statistical information without requiring any sort of data science expertise or delving into the technicalities of writing complex statistical calculations to get this visualization. The benefit of this visualization is that it is quite simple to create, no statistical coding is required with PAW doing all ...

IBM Planning Analytics review against key software quality attributes While reading the excerpts from various books and journals on https://www.sciencedirect.com/topics/computer-science/software-quality-attribute 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 ...

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 ...

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 ...

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 ...

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 ...

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). ...

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 ...

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 ...

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 ...