Skip to Content
author's profile photo Former Member
Former Member

SAP HANA integration with Cognos TM1

Hi,

I want to check if data from Hana can be exported to Cognos TM1. As TM1 has more analysis functions for actual and Plan fianced data ( as BW SEM).

Can anyone please advise on pros and cons of the below scenarios or is it possible to integrate in below method.

1) Can Cognos TM1 can read directly integrate with HANA and load the data. If yes pls give an outline on steps

2) Can TurboIntegrator ( similar to BODS ) can read data from Hana and then load to Cognos TM1. TurboIntegrator and Cognos setup is already in place only need to check if TurboIntegrator can read the views in Hana.

3)Can BODS pull data from Hana into data staging and then load to Cognos. Can BODS load data using turboIntegator into Cognos or load data from BODS into Cognos TM1 directly.

4) Any pros and con on loading data from HANA to Cognos TM1 using ODBC Concept.

I know that data export from hana is not and ideal methodology but business requies it and we have to load data from HANA to Cognos TM1 not from ECC to Cognos .

Any help would be greatly appreciated.

Thanks,

Venkat.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 07, 2014 at 09:19 PM

    Isn't TM1 in(PC)memory? the main HANA's benefit is that aggregations happen on the database server and only the results are returned to a BI (for me it's Excel) client. why would you like to copy detail into TM1 (not sure if it's doable) and not create a bunch of HANA calculation views and expose them through ODBO into the spreadsheet pivot table?

    i don't think TM1 folks care that much about HANA, but then again spreadsheet users don't necessarily care about TM1.

    just an architectural thought or two...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.