Forum Discussion
Connect to IBM Cognos/TM1/Planning Analytics
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 SQ...
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
karaoan
Kudo Kingpin
Kudo KingpinHi 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