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

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

TM1 Rest API: Dimensions Metadata Extract

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

Backup and Restoration PAW- Dashboards, Workbooks and views

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

Biggest release since 2015 - Planning Analytics Workspace 2.0.57

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

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

Octane Celebrates 4th Anniversary

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

Session Timeout for TM1Web, PAW and PAX

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

TM1 Undocumented Function - Renaming the Element Name

0
3 min

Renaming the element name – SwapAliasWithPrincipalName  In Realtime Scenarios, sometimes we get the requirement to correct/update the Principal element name(s) in a Dimension. This would relatively be easy if the dimension is being used in one cube. In case where the dimension is used in multiple cubes, updating element name(s) without affecting the data of all the cubes, is a bit challenging. Either we export data of the cube and change the element name(s), then import the data and validate cube before and after the element change. Or deploy the Bedrock process, which requires the reboot of ...

TM1: Feeder-Less Feeding

0
3 min

Many Developers like to stay away from the topic call Feeders in TM1 / Planning Analytics world but on the other side we cannot avoid Feeders as it plays the most crucial role while Modelling the data flow. Sometimes, dealing with Feeders may result in 2 major issues: 1. Over Feeding - Performance issue. - RAM consumption. 2. Under Feeding - Totalling issue To avoid this there is a small concept called Feeder-Less Feeding where we can avoid writing Feeders and Feeder related issues.   About: Feeder-Less Feeding is a Concept of Modelling the data in such a way where you write a Rule in TM1 ...