SAP HANA integration with Cognos TM1

[Former Member]

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.

[Former Member]

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...

[Former Member]

Hi Gregory,

Thanks for the response,

Current scenario at  the client is,  SAP BW data was loading into Cognos but they have  replaced SAP BW with stand alone hana( not BW on Hana).  In Hana a calucation view , similar to the logic of SAP BW cube is created and loaded with data.So the output of caluclation view in Hana should be loaded to Cognos TM1. They have cubes in cognos which has scripts and transformations to do further analysis.

As all the all the logic in TM1 is in place  and users are comfortable in using Cognos, we don't have an option of chaning the whole scenario. Only option is load data from HANA to Cognos .

Thanks,

Ravi.

[Former Member]

you can open a message with SAP to see if there's an official support, but I would be surprised if there was one as these are competing products.

sounds like you may need to extend (rewrite, 'push down') your Cognos cubes into HANA calc views which should be easy as you have already done so before sending the logic into Cognos.

good luck,

gm

[Former Member]

I will check with SAP support.

Its easy to  push the cognos logic into HANA but client does not want Hana has planning box. They want use Cognos for planning  finance data. I don't have control on that.

Only Option with given  constraints and the timeframe, have to load data from HANA TO cognos.

Thanks,

Ravi.

[Former Member]

I'm sure that, for a fee, there is more than one company out there that will provide HANA calc view to Cognos cube integration.

How much is your client willing to spend?

[former_member195748]

Hello Venkat,

I know its quite a old post, but did you managed to push data from hana to Tm1. I have similar requirement.