Native HANA db vs BW on HANA db

[former_member201560]

Dear all,

We are building one application with SAP Native HANA as backend, where we are creating analytical / calcuation views and stored procedures according to the business requirements.

Currently, the requirement was to import HANA BW cubes (from another instance) into Native HANA.

Instead of using separate HANA db instance, can we use the BW on HANA database instance to create analytical / calculation views and stored procedures, so that we can avoid one HANA db instance.

Please let us know with your views and what is the difference between Native HANA and BW on HANA(database) w.r.to building applications

Regards,

Yogesh

[vivekbhoj · Accepted solution]

Hi Yogesh,

You can import BW cubes in your BW on HANA instance and then you can use that view in your other customized views or procedures

Don't directly modify the view created from importing BW Models.

Earlier it was not possible to import Cubes (from another instance) into Native HANA although in non productive system it could be possible

Watch the recording on HANA Landscape and Architecture:

http://www.saphana.com/community/blogs/blog/2013/12/03/whats-new-in-sap-hana-sps07

Also check the below document about it:

What´s New? SAP HANA SPS 07 Architecture ... | SAP HANA

Regards,

Vivek

[Former Member]

If you are on BW 7.4 then there are a bunch of options - see this blog:

http://www.saphana.com/community/blogs/blog/2013/11/26/teched-recap-bw-740

I would advise using BW on HANA if you want to use BW cubes. Otherwise you have or replicate out of BW into HANA.

John

[former_member201560]

Hi John,

Thanks for your reply.

Actually, Can we use single database(BW on HANA) instead of Native HANA. I mean we have BW running on HANA database, can we use this database for creating analytical and calculation views as per the business requirements for building new application on top of this HANA database ?

The bottomline is to have single HANA database where we need to have BW and to create/build applications.

Please let us know with your valuable inputs.

Regards,

Yogesh

[Former Member]

Technically, yes, but there are different license models so you should talk to your account team.

But yes you can implement BWoH and then put calc views on top.

[henrique_pinto]

Actually, as long as the physical (materialized) tables are only created by the BW applicaiton layer, the current HANA, Runtime edition for BW usage rights allows the creation of virtual views on top.

[former_member209292]

Hi Yogesh,

Please read Erich blog about this recurrent question on the multitenancy rules and "what is the difference between MCOS, MCOD etc. and what is possible with HANA?".

http://www.saphana.com/docs/DOC-2135

Regards

Patrick