Connect to IBM Cognos/TM1/Planning Analytics

[Anonymous]

Hi everyone, 

What is the best way to connect PBI to Cognos/TM1/Planning Analytics cubes? 

I know there is no connector built into PBI at the moment for this. Instead of dumping cubes into a SQL DB and connecting PBI that way, i want to go direct from the IBM environment to PBI.

Any help is appreciated!

Thanks

[micatio]

Hi All,

There is now an TM1 Custom Data Connector which you can use in Power BI to access Views and execute raw MDX. 

Its available from https://micatio.com/products-and-services/tm1-power-bi-custom-connector/

Kind Regards,

Ron

[Anonymous]

Hi @Anonymous  were you able to implement any thing?

[Martin_Liwosz]

Introducing DataFusion

Based on open-source web-technologies, Octane's DataFusion bridges the integration voids between IBM Planning Analytics and various Analytics & Business Intelligence platforms like Microsoft Power BI, Qlik and Tableau.

All connections formed through DataFusion are web-based and integrate entirely without the need of a centralised database. The user-interface and navigation, built keeping in mind a user friendly design and dynamic page layout, makes working with DataFusion fast and easy.

DataFusion blends into your business applications environment using existing views with native IBM Planning Analytics security. It can also be customised to dynamically create views and get data that you are looking for. DataFusion is attuned to address your specific business needs and can be augmented further using industry standard tools and APIs. All you need do is let Octane know and we'll get right to them.

DataFusion helps you deliver a true version of the truth across your enterprise ""real-time"", thereby accelerating business decision making and enhancing performance.

http://www.octanesolutions.com.au/datafusion/

[karaoan]

Hi Ben,

As an alternative you could consider https://www.acterys.com a solution that we have developed as a "TM1 for SQL Server". It offers similar modelling, write-back / planning features with the advantage that all data is stored in a single SQL database (cloud or on premise)

Martin

[JLITLink]

Hi Ben

Sorry for the late reply, thanks for trying TMVGate, glad it worked well for you.

For anyone facing similar problems, please feel free to try the free TMVGate trial. TMVGate is a purpose-built gateway and an efficient solution. It allows you to connect your data in Planning Analytics/TM1 to industry leading BI tools like PowerBI.

It has a lightweight server based architecture and does not require any software or driver on the client workstation, making it ideal for widespread deployment.

TMVGate returns Cube view (private or public) and Dimension Hierarchies data in real time streaming in either the JSON, XML, HTML or CSV (TXT or Pipe) format via a simple HTTP or HTTPS call. The various data streaming formats have been validated with the visualization tools mentioned, without the need for any additional scripting.

You can watch the demo videos on our Youtube channel here:

https://www.youtube.com/channel/UC95AcZmT7jByvMfWDCIWbWw 

Please send us an email if you'd like a free TMVGate trial we'll get back to you in as soon as possible. Most of our clients don't even require half of the free trial time to get their required results. 
Email: info@itlinkbiz.com or visit our website at https://www.itlinkbizs.com

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Please review my reply in the similar thread below. You can able to use ODBC connector or web connector in Power BI Desktop to connect to Cognos TM1 database.

https://community.powerbi.com/t5/Integrations-with-Files-and/Connection-to-IBM-Cognos-TM1-via-OData/td-p/131562

Regards,
Lydia