MII working together with HANA

[Private_Member_17892]

Hi ,

I recently started to have a look at SAP HANA, impressive technology I must say.

Now my question is how do you see MII integrating with HANA, and will MII in your view/opinion have a place once HANA takes off ?

Has anyone had experience in doing such an integration yet, or planning to ?

Is there any one maybe in the MII development team that has an opinion or view on this ?

[Former Member]

Hi All,

I was wondering if we have any restrictions using CTS+ with MII working on HANA DB. We are planning on going with MII 15.1 with SAP S/4 HANA so want to know how project transports can be better handled in MII.

[RajeevKansal]

Hi,

CTS+ transport remains unchanged even if you use SAP MII with HANA DB.

you can transport projects and configuration data using CTS+.

thanks

Rajeev

[Former Member]

Sam Castro put some document together on integrating MII, ESP and HANA !! see here !!

[agentry_src]

HANA's strength is in processing massive amounts of data, very rapidly. MII has a number of strengths (connectivity, integration of different data sources, rapid development of dashboards, etc.). Not sure where a point of competition would occur.

One area that they could share (IMHO) would be analytics applied to process historians (who have huge amounts of data). Not sure who is working on this, if anyone. But there would be some great amounts of data which could be analyzed by HANA and perhaps presented or distributed by MII.

Regards,

Mike

[Private_Member_17892]

Thanks Michael,

I have delved a bit more into it and started to see more how this technology can benefit us, especially where we currently have a large number of calculations that needs to be done and where HANA can definitely improve the delivery of these calculations that is to be done ....

I'm looking forward in doing such an implementation....

[former_member4529]

Hi,

As SAP MII 15.0 can use HANA as database, I was wondering how MII can leverage the features and power of HANA for its development.

If we write the calculation logic in BLS only, it won't use the power and features of HANA. Ideally the complex data logic should be embedded in calculation views when MII is installed on HANA.

As I understand MDOs created in MII are created as columnar tables in HANA, but with cryptic names of tables and columns (MDOxx, FIELDxx) in the HANA (DB) layer. As there is no provision to create the attributes, analytics and calculation views in MII directly, those need to be created in HANA layer from HANA studio. Now the issue is how can we identify and access the correct MDO tables as those are not visible in HANA with the user-defined MDO names.

The other option may be creating the tables also directly in HANA, but that will bypass the MDO features and content management features of MII. My understanding is the HANA tables and views can be accessed from MII from the SQL query templates.

Can anyone please throw some light on this on how we can leverage the features of HANA in this case?

Thanks,

Dipankar

[Former Member]

Good question Dipankar Saha !!!

[former_member4529]

Hi,

I recently come to know from SAP MII product development team that the MDO naming issue is fixed in MII 15.1. You will be able to specify a fixed name for MDO and KPI objects from the workbench.

Thanks,

Dipankar

[former_member4529]

You can refer my blog on this topic :