As SAP HANA might not only a database for selecting and inserting operations you can use the HANA itself for modelling in-memory business scenarios. The advantage is a further significant performance improvement due to a complete in-memory calculation.

sap_bwonhana_0For example massive data calculations. You can do the calculation as start routine in SAP BW on HANA. The data for calculation will be selected fast due to the SAP HANA in-memory database but the calculcation in the start routin has nothing to do with in-memory: it happens on the SAP BW application server. Alternatively you can push the calculation in a SAP HANA model. The application server SAP BW will just receive the results. The results can be migrated in SAP BW on different ways.

sap_bwonhana_1Either by virtual data providers or by virtual master data provider. Due to a complete calculation in-memory retrieving the data from SAP HANA models will be always virtual.

I prefer using the Virtual Provider as you can use your already created InfoObjects with their attributes and texts (attributes of an InfoObject must be assigned as well from the SAP HANA model!). You can use as well a Transient Provider which will create temporary InfoObjects based on you SAP HANA model.

Both Providers can be included into the Composite Provider but only the VirtualProvider can be used in the classical MultiProvider. The CompositeProvider has the advantage that it can JOIN the Provider whereas the MultiProvider simply UNION the Provider.

sap_bwonhana_2On the other site, we have the possibility to retrieve into a virtual InfoObject. Simply use the option to receive the data from a SAP HANA model when you create a InfoObject. A Master Data Read Class will be automatically created. Whether you can user customer exits on the Mast Data Read Class is not tested by me yet :)

A further improvement is not only building SAP HANA models but to create performance oriented procedures or models in SAP HANA. Similiar the same as you would do in SAP BW. Therefore you can boost your performance and you will receive the full power of SAP HANA. Of course, SAP BW on HANA might be one example as exactly the same ca be done for a SAP ERP on HANA. Maybe not for analytics but also for fast calculations which will be inserted in a DDIC table for a SAP application for SAP ERP.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Antony Jerald J

    Hi,

    Really a good content!! Thanks for sharing.

    How ever, I m not clear with the following content:

    but the calculcation in the start routin has nothing to do with in-memory: it happens on the SAP BW application server. Alternatively you can push the calculation in a SAP HANA model. The application server SAP BW will just receive the results.

    As said, all the operations happen at database level(Hana).  How does calculation in start routine takes at application server level?

    Why it’s not in memory here?

    Could you please give me clarity on my following query?

    it’s said that 5% of Hana tables are row store and 95% are column store.  On what basis the tables on BW are directed to column store?

    Regards,

    Anton Jerald.

    (0) 
    1. Gabor Kovacs

      Hi,

      Please visit BW on HANA FAQ | SAP HANA – it has answers to most of the questions you may have regarding BW on HANA!

      Regarding the content above – the so called ‘mixed scenarios’ are discussed here in more details (also check the SAP online help):

      Modeling SAP NetWeaver BW and SAP HANA Mixed Scenarios – Webinar Replay

      Modeling SAP NetWeaver BW and SAP HANA Mixed Scenarios – Webinar Presentation

      SAP NetWeaver BW / SAP HANA Mixed Scenarios – News, Added Value, and Customer Examples- Webinar Presentaiton

      Specificly to your question: ABAP processing (like the start/end routine) takes place on the application server.

      However with SAP Netweaver BW 7.4 SP5 you have more and improved options (SAP Business Warehouse 7.4 ).

      For ABAP programming on top of HANA please visit ABAP for SAP HANA and ABAP Platform Developer Center

      Regards,

      Gabor

      (0) 

Leave a Reply