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

6 Reasons why you should get DataFusion - a TM1 connector

0
3 min

DataFusion is a TM1 connector developed by Octane. It was borne out of the frustration clients were facing extracting data out of their IBM Planning Analytics application into other enterprise Reporting tools like Power BI, Tableau and Qlik. Typically this was set up as a manual task that required an IT or Finance person to drop a csv and upload into Reporting tools. This created a number of issues. Firstly it required the operator to ensure that the correct slab of data has been captured and uploaded. It also created a risk as end users would have to rely on operator to perform this task on ...

Introduction to TM1 REST API

2
5 min

REST stands for REpresentational State Transfer. It is web standard-based architecture and uses HTTP Protocol. TM1 REST API is a type of web service which can be used to perform create, read, update, and delete operations on TM1 objects or data. Therefore, we can maintain a TM1 model, manage TI processes, chores, dimensions and query data that is stored in the model. TM1 REST API provides an Open Data Protocol (OData) Version 4 compliant interface to TM1 server, which allows clients to query and update data sources that are hosted by TM1 Server. The OData standard defines a set of rules and ...

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

COVID-19 Update: Protecting our Associates and Clients

0
3 min

In light of the heightened level of concern related to the spread of Coronavirus (COVIS-19) we want to provide an update on the actions Octane is taking to safeguard the health-being of our clients, our associates and their families. All of our 7 offices around Australia, India and Middle East are continuing to serve the needs of our clients. For your and our safety we are following the guidelines in respective countries public health authorities. We are monitoring the situation daily and continue to take guidance from public health authorities. There are number of steps we have taken as part ...

Planning Analytics Administration: An Alert (Proactive Mechanism)

0
3 min

Gone days, where we had no control/alerts mechanism on the TM1 database, CPU/memory it consumes, react at the nick of the moment before TM1 server crashes. I am sure all TM1 lovers, administrators and business users who had these experiences in the past would connect to what I am referring to. For all new Planning Analytics users, in earlier versions of TM1/ Planning Analytics, we had little overview on how much on RAM/ memory can a TM1 instance use/utilize or have an inbuilt alter mechanism.  TM1 Database Alert Mechanism:  Issue:  Most of you know, TM1 Server loves memory/RAM, more memory ...

Automation in TM1 using AutoHotkey

0
3 min

This blog explains a few TM1 tasks which can be automated using AutoHotKey. For those who don't already know, AutoHotKey is open-source scripting language used for automation. 1. Run TM1 Process history from TM1 Serverlog : With the help of AutoHotKey, we can read each line of a text file by using loop function and content is stored automatically in an in-built variable of function. We can also read filenames inside a folder using same function and again filenames will be stored in an in-built variable. Therefore, by making use of this we can extract Tm1 process information from Tm1 Serverlog ...

Potential Data Loss: Quick Fix a must : PA Cloud and PA Local

0
5 min

IBM has identified a defect within the code introduced in TM1 10.2.2 Fixpack 7, part of all other releases before 2.0.9. This defect causes data loss within the cubes even after performing SaveDataAll activity with in TM1 server. Let us get into the details. What is the defect : Possibility of losing data even after SaveDataAll activity is performed. This defect (APAR PH19984) has been identified recently by IBM. This will only trigger when below conditions are met. No-SaveDataAll : If SavedataAll not performed since TM1 Server was rebooted. Lock Contention : Lock contention specific to ...

Our path to gold ... The Octane Journey

0
4 min

  Octane turned 3 this year and to put icing on the cake Octane just attained the status of IBM Gold Business Partner. Sounds a bit of founder’s cliche, however it really has been an extraordinary journey. It all started with a passion to fill a gap in the market. Biggest task though was building a team that is equally passionate and sold on the idea of transforming how a vendor could play a more strategic role in partnering with clients to shape their Data and Business Intelligence objectives to deliver actionable insights. After having interacted with most of the vendors in this space over ...

Planning Analytics for Excel: Trace TI status

0
2 min

IBM has been recommending its users to move to Planning Analytics for Excel (PAX) from TM1 Perspective and/or from TM1 Web. This blog is dedicated to clients who have either recently adopted PAX or contemplating too and sharing steps on how to trace/watch TI process status while running process using Planning Analytics for Excel. Steps below should be followed to run processes and to check TI process status. 1. Once you connect to Planning Analytics for Excel, you will be able to see cubes on the right-hand side, else you may need to click on Task Pane.     2. Click on the middle icon as ...