Cognos TM1 as data source in Microsft BI

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Cognos TM1 as data source in Microsft BI

Post by mce »

Hello team,

Did anyone of you used TM1 cubes as data source Microfoft BI tools, such as PowerBI?

If you are interested in having this feature in MS BI, please vote here:

https://support.powerbi.com/forums/2652 ... ata-source

Regards
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Cognos TM1 as data source in Microsft BI

Post by mce »

I just saw the post in http://www.tm1forum.com/viewtopic.php?f ... it=powerbi
It looks third party Gateway product helps with this.
nick_leeson
Posts: 98
Joined: Sat Feb 11, 2012 11:13 am
OLAP Product: TM1 9x, BPC, Hyperion, HANA
Version: TM1 10
Excel Version: Excel 2003 - 2010

Re: Cognos TM1 as data source in Microsft BI

Post by nick_leeson »

Power Query natively supports Odata V4 Payload which is the format you will get if you enable REST API on TM1 10.2.2 hence I would rather go down that path.

https://support.office.com/en-us/articl ... _176341939

I have not tested that yet but looks promising from a visual perspective .

Cheers
kangkc
Community Contributor
Posts: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore
Contact:

Re: Cognos TM1 as data source in Microsft BI

Post by kangkc »

Unfortunately it 's not a straight forward task of using OData connection from PowerBI with TM1 Rest. Give it a test and you will know the issues.
davidkerby
Posts: 1
Joined: Wed Apr 26, 2017 7:50 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Cognos TM1 as data source in Microsft BI

Post by davidkerby »

Hi, if you are looking to report from TM1 within PowerBI, you might be interested in the connector we have built to do this. If you'd like to discuss this further please email me at Dave.kerby@simpson-associates.co.uk

Thanks
Dave
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: Cognos TM1 as data source in Microsft BI

Post by stephen waters »

CarpeDatum have a connector, TM1Connect, which links TM1 to Power BI (pLus Tableau and Qlik I think).

We are currently working with one of our clients on the Power BI\TM1 connection and initial tests results are good.

I think a couple of other partners have something similar as well.
Post Reply