<img src="https://trc.taboola.com/1278851/log/3/unip?en=page_view" width="0" height="0" style="display:none">
finding octane

Amin Mohammed is a Solutions Architect, Project Team Leader and a professional trainer with over 10 years of project design, implementation and project management experience. He has successfully led and delivered multiple offshore as well as onshore projects globally.

Create statistical visualization in PAW using BOX Plots

0
4 min

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

0
8 min

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

Merging multiple Dynamic Reports in PAfE using Power Query

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

Dynamic Arrays and Its Impact on Planning Analytics for Excel

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

Data Analysis using Dynamic Array formulas

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

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

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

Changing password in multiple TM1 instances

0
3 min

I recently came across a problem statement at a client site and thought it would make good content to share for my blog article so without further ado here it goes... Background: The customer uses PA Local with native TM1 security and has recently added a new TM1 instance. As we are aware, to be able to login to PAW, the user’s login credentials must be same on all TM1 servers. Now the challenge was the users normally change their passwords from TM1Web login page which means they have to login twice to change their passwords – one for each server. I considered this a little problematic ...

Adding images in PAW

2
4 min

In this article I would like to share a very useful tip on how we can use different methods to adding images in Planning Analytics Workspace; one that is very well known, one that is lesser-known and one that is relatively unknown. I intend to touch base on the first two methods while focusing more on the latter one.  But before I begin, as I write this blog article, there has been more than 2 million confirmed cases of COVID-19 worldwide with over 130,00 deaths and I wish to take a moment on behalf of Octane Software Solutions and express our deepest condolences with all those and their ...

Adding customizations to Planning Analytics Workspace

0
4 min

IBM, in Planning Analytics Workspace’s 2.0.45 release however has addressed some limitations by extending the flexibility to users to upload the fonts and color themes of their choice in Workspace and apply it in their visualisations. One of the common complaints that I constantly hear from users and have myself put up with when using Planning Analytics Workspace is its lack of available fonts and color pallets for its visualisations. The lack of this flexibility put  a hard restriction on designing intuitive interfaces and dashboards as we’re limited by only a certain fonts or color ...

Pax-PMHub-less

0
2 min

PM Hub – Why go Hub-less? As a part of Planning Analytics for Excel version 2.0.42 release on 13th May 2019, the PAX has gone PMHub-less, meaning it no longer requires Performance Management Hub, also known as PMHub. So what does that mean for you? But before that let’s first understand what roles does PMHub play in IBM Planning Analytics architecture framework. What is Performance Management Hub?   To put it simply, it is a web based application in Application layer within a typical server framework and a web based user interface that provides necessary application services wherein ...