Cognos TM1 as a data source
Would be great to have Cognos TM1 cubes as a data source for PowerQuery/Power BI Designer.
I work in Cognos TM1 and i am learning Power BI using online videos (really liked out). Now i am checking if there is a good direct connector between Cognos TM1 and Power BI so that i can make use and show case to clients and users. Please help if you know.
Andrey Yakimov commented
Would be sweet to have
Patrick Walter commented
There is a other Solution for the IBM Cognos Users to integrate Data from Cognos to Power BI. A simple Solution is the creation of Export Files in ".csv" format, so you can import these files in Power BI as Excel Sheets.
I have been talked with many IBM Cognos consultants and nobody know´s that there is a directly interface from Cognos to Power BI.
Migration from cognos to Power BI will be helpful
David Fletcher commented
Hi. We've built some really powerful TM1 reporting cubes we would like to bring into the power BI world. What is critical for success is being able to display the new alternate hierarchy functionality. great enhancement to the self-serve world
Ashok Kumar Veluru commented
Enabling Power BI to TM1 connectivity will save lot of our time and effort with data modelling
Carlos Julio commented
we have cognos database it will be the perfect combination if you guys are able to create this connector. Power BI gives us the flexibility and user-friendly interface and cognos give us the security and structure for our data.
I see lots of security issues TM1 will have but itll always be good to have
we all should go out for a drink one day this is achieved. so eager to see this is happening tomorrow!
Deepak Shahdadpuri commented
Great idea, expecting a positive response as always.
Paul Southerland commented
This is needed for Power BI to provide self-service functionality for organizations that had previously committed to TM1 for corporate data warehouse solutions
Luis Lucchini commented
Please, please guys please.
Yes. This is very much needed. I have come across many customers asking for this.
Ricardo Montero commented
Jialiang Wang commented
For those who are encountering similar difficulties connecting IBM PA/TM1 cubes to PowerBI, you might like to give TMVGate a try.
TMVGate was specifically built to allow users to connect their 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:
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: firstname.lastname@example.org or visit our website at https://www.itlinkbizs.com
Any update on this? We have plenty of clients using TM1 for their heavy lifting analytics and would love to create outputs in PBI