Skip to Content
Author's profile photo prabhith prabhakaran

SAP BW 7.4 Powered by HANA — Promising Features (Part 1)

Hi All,


Recently, I got a chance to work on a project which involved SAP BW 7.4 SP5.

The latest SP5 of SAP BW 7.4 powered by HANA comes up with a lot of new and enhanced features.

I have tried to explore the so called new features and has taken the help of HELP.SAP wherever required.


This would be the First in the 4 part series of documents which will take you through the various new features.

Part 2 of the series can be found in the link :  http://scn.sap.com/docs/DOC-53210

Part 3 of the series can be found in the link :  http://scn.sap.com/docs/DOC-53527

Part 4 of the series can be found in the link :  http://scn.sap.com/docs/DOC-53505


1) Implementation Methodology:

/wp-content/uploads/2014/03/1_407991.jpg


2) System status

    /wp-content/uploads/2014/03/2_407997.png   /wp-content/uploads/2014/03/3_407998.png

3)  2 New entries in Modelling Tab:

       /wp-content/uploads/2014/03/4_408005.png

a) History: In modeling, a new view has been introduced for the history of actions performed on BW objects. In the history, the navigatable actions on objects (display and change for example) are displayed for the current Data Warehousing Workbench session. These actions can be called from the history. This provides you for example with quick access to the maintenance screen for objects that you have already worked on during this session.


          /wp-content/uploads/2014/03/5_408006.png


b)  SAP HANA Analysis Process (HAP):   You can use a SAP HANA analysis process to analyze data from certain perspectives, for example to   calculate ABC classes or to find scoring information. You can use the functions of the SAP HANA database, which you can combine with the functions of the BW system.

Please find the SAP documentation link on HAP:

http://help.sap.com/saphelp_nw74/helpdata/en/75/55bb05654c49398f07a038a2ff2c06/content.htm?frameset=/en/10/c0666ed4a24e9d81e90e78d9a21fca/frameset.htm



Please find the navigation path how to create a new HANA analysis process tab:

  1. Double click on the SAP HANA Analysis process under the modelling tab.
  2. All the Info areas and the available HAP’s would be shown in the right side.
  3. Create a new HAP under the required Info Area.

     /wp-content/uploads/2014/03/6_408012.png


  d.   A screen like below with 4 tabs will be shown.

        /wp-content/uploads/2014/03/7_408013.png
  e. You need to model your HAP based on data source, data analysis and data target.

   

  f.   The Following are the options available under the Data source:

         /wp-content/uploads/2014/03/8_408018.png

  g.   Following are some of the functions available under Data Analysis: 

          /wp-content/uploads/2014/03/9_408020.png

   h.   The following are the screens under the different tabs:

           /wp-content/uploads/2014/03/10_408021.png   

            /wp-content/uploads/2014/03/11_408022.png

               /wp-content/uploads/2014/03/12_408023.png

                 

i.   The HAP Process can now be included in Process Chain

                /wp-content/uploads/2014/03/14_408025.png


4)  OPEN ODS View:


a.  Right Click on Info Area –> Create Open ODS view.              

                    /wp-content/uploads/2014/03/15_408030.png

b.  Enter the name, description, Semantics and Type

                    /wp-content/uploads/2014/03/16_408031.png

                       

                     /wp-content/uploads/2014/03/17_408032.png

c.  Following are the various screens under different tabs.

                        /wp-content/uploads/2014/03/18_408033.png

                           /wp-content/uploads/2014/03/19_408034.png


                             /wp-content/uploads/2014/03/20_408036.png


                             /wp-content/uploads/2014/03/21_408037.png


Note: In BW, you can use SAP HANA Smart Data Access as the source for Open ODS views and for query access to data in Sybase IQ as a near-line storage solution.

SAP HANA Smart Data Access make it possible to access external data, without having to replicate the data to the SAP HANA database beforehand. You can connect supported databases – such as SAP Sybase ASE, SAP Sybase IQ, Intel Distribution for Apache Hadoop, Teradata and SAP HANA – to the BW SAP HANA database. SAP HANA handles the data sources like local tables on the database (known as “virtual tables”).

If you use SAP HANA Smart Data Access, query execution is optimized by moving processing (whenever possible) to the database connected by SAP HANA Smart Data Access. In addition, SAP HANA Smart Data Access provides more options to consume external data sources using Open ODS views and integrate these sources into BW.

  Please find some links which shows the Open ODS concept in detail with real time examples:

https://help.sap.com/saphelp_nw74/helpdata/en/3c/2501f075cb42b1aef74b6b4e5fa9de/content.htm


http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2013/12/29/teched2013-bw-74-feature–ods-view


  http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40f377fd-194d-3110-469b-82a4131689cf?  =index&overridelayout=true&58987080855969




5)  The characteristics definition screen has changed and now we have some additions aswell.


                               /wp-content/uploads/2014/03/22_408047.png

                                  /wp-content/uploads/2014/03/23_408048.png     

6)   Now we have some additional help while creating the Characteristics Objects:

                                   /wp-content/uploads/2014/03/26_408049.png

                 

                    /wp-content/uploads/2014/03/27_408053.png

Hope  you got a glimpse of some of the  new features that has come up in BW7.4.

Regards,

Prabhith

       

Assigned tags

      22 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo abilash n
      abilash n

      Excellent blog Prabith..... I got overview on 7.3 even from your old blog. Thanks it helped me in implementing in my project.

      Author's profile photo Former Member
      Former Member

      thanks for sharing

      regards

      Raj

      Author's profile photo Former Member
      Former Member

      Very Useful Document

      Regards,

      Sushant

      Author's profile photo Former Member
      Former Member

      Thanks Prabhith

      Equally interestig like your BW7.3 Article published a year ago!

      Thanks,

      Amrith

      Author's profile photo Former Member
      Former Member

      Hi,

      Thanks for sharing/

      Waiting for your part 2and 3 aswell.

      Regards

      KP

      Author's profile photo Ramesh Duraisamy
      Ramesh Duraisamy

      Good one Prabhith, please tag part 2 and 3 as well.

      Thanks and Regards,

      Ramesh D

      Author's profile photo Former Member
      Former Member

      Good one, Prabhith.

      Thanks for sharing...

      regards,

      Lethika

      Author's profile photo Former Member
      Former Member

      Excellent one!!! Good work Prabhith and thanks for sharing with us!

      Author's profile photo Former Member
      Former Member

      Thanks for sharing Prabhitha, Excellent doc

      Author's profile photo Sriram Vijay R
      Sriram Vijay R

      Thank you very much for sharing!!

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Appreciate your thought to share this fantastic Info with us 🙂 Great compilation 🙂 🙂

      Author's profile photo Rama Shankar
      Rama Shankar

      Great Blog - thanks 🙂

      Author's profile photo Former Member
      Former Member

      Perfect blog,thanks

      Author's profile photo Anil Muppa
      Anil Muppa

      Thanks. Very useful...

      Author's profile photo mani kanta
      mani kanta

      Hi Prabith,

      Nice one please keep on sharing.

      regards,

      manikanta

      Author's profile photo Former Member
      Former Member

      Hi Prabith,

      Good blog.

      Can you please share any doc on Open ODS View.

      Thanks,

      Hari

      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran
      Blog Post Author
      Author's profile photo Former Member
      Former Member

      Thanks, Very good.

      Cheers

      Anil

      Author's profile photo Former Member
      Former Member

      Very Nice blog. Thanks for sharing.

      Regards,

      Anupama

      Author's profile photo Rajesh Ramakrishnan
      Rajesh Ramakrishnan

      excellent document!

      Thanks!

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Hi Prabhith, Very useful blog thanks for the screenshots. Giving a 5 Star rating. 🙂

      Regards-Ashok

      Author's profile photo Rajesh Ramakrishnan
      Rajesh Ramakrishnan

      Good One.