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

Blog

6 Reasons why you should get DataFusion - a TM1 connector

[fa icon="calendar"] June 10, 2020 / by Kunal Ghewade

Kunal Ghewade

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 as regular basis as required. This created a single person dependency and if he or she is on leave the data may not get refreshed as teams scramble to find out how to do this task.

 

The other issue with this approach was a lack of consistency. Being manual the end users would not have a clear idea of when the data from Planning analytics was uploaded. There also was a constant reconciliation issue as numbers would move in Planning Analytics TM1 and would not be reflected in the Reporting tools in a timely manner.

 

Enter Data Fusion – This is a Planning Analytics TM1 connector Octane has developed to solve this problem. This allows your Planning Analytics TM1 to connect to all major Reporting tools (Power BI, Tableau and Qlik). Datafusion comes with an easy to navigate admin portal to allow admin to set up the data block amongst frequency of data flow to reporting tools. End users can be given access to load data on an ad hoc basis if required. Datafusion uses TM1 security for data access.

 

Datafusion not only brings in the updated Data but also metadata so if you have a new element like a store/division or region in you Planning Analytics TM1 it will flow through to your reporting tool automatically.

 

  1. Data Accessibility

Quick and direct data accessibility from all major reporting tools. Ensure your reporting tools across enterprise are reporting on the most up to date data and everyone is using the same numbers for reporting

  1. Automation

Set up the connector once and it runs automatically. All processes are automated and requires no human intervention for scheduled runs.

  1. Efficiency

Reduces the turnaround time of the data refresh process by direct and automated process. Also eliminate all your reconciliation issues with varying numbers between Planning Analytics TM1 and your Power BI’s, Tableau and Qlik.

  1. User friendly design

Easy to use interface and quick setup. Fully supported by Octanes Support teams.

  1. Data Flexibility

Flexible enough to extract any new records with new elements built. Bring in data and metadata and have it displayed in your reports automatically

  1. Eliminate Data issue

There is zero manual handling of data and almost fool proof for your data reconciliations and traceability of data in your Reports.

 

If you are using Planning Analytics TM1 and taking data out using csv or any other manual method then you should contact us for a demo to see how DataFusion can automate this process for you.

 

Connect TM1 to Power BI

 

Topics: DataFusion

Kunal Ghewade

Written by Kunal Ghewade

Kunal is a IBM Planning Analytics (TM1) Developer at Octane Software Solutions. A Business Analyst and MBA in Finance, he's passionate about helping industries develop their business insights and process management. Kunal is a Young Turk at heart, Creative and Passionate.

Subscribe to Email Updates

Recent Posts