Skip to main content

    Power BI

    Needs Votes

    Cognos TM1 as a data source

    Vote (576) Share
    Ron Pooters's profile image

    Ron Pooters on 21 Apr 2015 00:56:18

    Would be great to have Cognos TM1 cubes as a data source for PowerQuery/Power BI Designer.

    Comments (97)
    Ron Pooters's profile image Profile Picture

    01a23ad8 3815-41f8-9d6b-14076d3f90e6 on 16 Aug 2020 03:54:29

    RE: Cognos TM1 as a data source

    Any updates from power BI?

    Ron Pooters's profile image Profile Picture

    40b02eeb 1046-4133-9f52-f84ff298d23c on 16 Aug 2020 03:54:05

    RE: Cognos TM1 as a data source

    We have just added drill down capability with our TM1 Gateway using Power BI In-line Hierarchy preview feature.
    See it in action at:

    https://www.youtube.com/watch?v=I4fb57rpuBs

    Ron Pooters's profile image Profile Picture

    787895ae d646-498b-b464-4e24011096cb on 16 Aug 2020 03:53:50

    RE: Cognos TM1 as a data source

    Anyone know the url specified to connect to the Cognos cubes through ODBC . I still can not see the data. Thank you

    Ron Pooters's profile image Profile Picture

    fade1bb6 2c8e-4549-9b17-53555f2bb44b on 16 Aug 2020 03:53:16

    RE: Cognos TM1 as a data source

    Any news from the power bi team on tm1?

    Ron Pooters's profile image Profile Picture

    ff792f46 eb91-4de5-9cdc-765d618d5cfd on 16 Aug 2020 03:53:12

    RE: Cognos TM1 as a data source

    Simple link Tm1 as a source of data for power bi

    Ron Pooters's profile image Profile Picture

    5e69bd8d 12e3-47bd-b1b5-2f4020f33f2c on 16 Aug 2020 03:51:31

    RE: Cognos TM1 as a data source

    It would have been very useful if Power BI support Cognos TM1 cubes as data source.

    Ron Pooters's profile image Profile Picture

    5e69bd8d 12e3-47bd-b1b5-2f4020f33f2c on 16 Aug 2020 03:51:31

    RE: Cognos TM1 as a data source

    that is great idea. Microsoft does not have a proper CPM solution. Hence Microsoft BI tools should support CPM cubes as data sources. The best CPM tool is IBM Cognos TM1. Hence PowerBI should support Cognos TM1 as data source.

    Ron Pooters's profile image Profile Picture

    40b02eeb 1046-4133-9f52-f84ff298d23c on 16 Aug 2020 03:51:31

    RE: Cognos TM1 as a data source

    We have gateway that works with CognosTM1. Send a mail to info@itlinkbiz.com for detail. Meanwhile see the demo:

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

    Ron Pooters's profile image Profile Picture

    23c240ba c654-47b6-bd8b-fe01501934ef on 16 Aug 2020 03:51:07

    RE: Cognos TM1 as a data source

    add TM1 as connector to load data

    Ron Pooters's profile image Profile Picture

    40b02eeb 1046-4133-9f52-f84ff298d23c on 16 Aug 2020 03:48:19

    RE: Cognos TM1 as a data source

    We have gateway that works with CognosTM1. Send a mail to info@itlinkbiz.com for detail. Meanwhile see the demo:

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