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 is the Second in the 4 part series of documents which will take you through the various new features.

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

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


7)  The Maximum length for Characteristic Infobject (Data type – CHAR) has been increased to 250.

/wp-content/uploads/2014/03/1_410192.png


8)  The Maximum length for Characteristic Infobject (Data type – NUMC) has been increased to 69.


    /wp-content/uploads/2014/03/2_410193.png


9)  New Options(Stock Coverage) available in Key Figure Definition.

      /wp-content/uploads/2014/03/3_410194.png



10) Now we have options to import the HANA models to BW.

      a) Create a Virtual Provider based on a SAP HANA Model.

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

      b)  Provide the Package and HANA Information model details:

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

  Please find the SAP link which shows the above scenario in detail:

  http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90d4dbe8-6ccf-3010-52b0-ab1d6ac97c82?  QuickLink=index&overridelayout=true&58600533823554


11) Some new options available in Find Screen.

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


12)  New House Keeping tasks added under Administration tab:

            /wp-content/uploads/2014/03/7_410201.png

Housekeeping for Requests (New) (Extracted from Help.Sap)

The new monitor allows you to monitor the number of requests contained in data targets of loading processes. Using the monitor, you can run housekeeping activities, which improve the performance for any actions carried out on requests and which make it possible to load significantly more requests into a data target than before.

In the Administration view of the Data Warehousing Workbench, go to  Housekeeping Tasks  Request Housekeeping (transaction RSREQREDUCE). Here you can open a monitor that provides you with an overview of the selected data targets. The overview contains data targets, which are critical with regards to the number of contained requests or how the number of requests develops.

If data targets contain a performance-critical number of requests, you can run housekeeping activities for these data targets in the monitor. Depending on the data target in question, you can delete requests, reduce the list of requests in the data target, and perform prerequisite actions for deleting or reducing requests. You can schedule and monitor these activities as periodic jobs.



13)  Some Standard formatting has been done in many areas:(Like First letter capital – see: Data Element in 1st Case,

Completed words – see: Field Definition in 2nd case)


Case 1:
 

                              Old Version:

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

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

                                    New Version                                                   



Case 2:

/wp-content/uploads/2014/03/11a_410213.png 10 a.png                                     

                              Old Version                                                              New Version



14)  Standard DSO’s have a new additional setting:(External SAP HANA View)   

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

15)  New Options and Changes in the create DSO Screen.

            /wp-content/uploads/2014/03/13_410215.png


16)  New Processing Mode in Transformation screen:

With execution in the SAP HANA database, you can obtain better performance when processing the transformation of the data transfer process.

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

  17)  Changes in RSDDB Screen.

          /wp-content/uploads/2014/03/15_410227.png
Query as Infoprovider option has been explianed in detail here:

http://scn.sap.com/community/bi-platform/businessobjects-bi-for-sap/blog/2013/05/24/using-sap-businessobjects-bi-4x-with-sap-bw-on-hana–publishing-a-bw-model-to-hana-part-2



18)  New ODP(Operational Data Provisioning)  source systems:   

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

        Transferring Data Using Operational Data Provisioning (ODP) (Extracted from Help.Sap)

Using the ODP data replication interface, developers can transfer data from specific SAP repositories (especially from SAP HANA and SAP Business ByDesign) to SAP NetWeaver Business Warehouse

Please find the SAP Link: https://help.sap.com/saphelp_nw73/helpdata/en/cc/6fac0c0533461986b9127b90ea7bde/frameset.htm


        The following changes and enhancements have been introduced for transferring data via ODP source systems: (Extracted from help.sap)

        New Process for Creating ODP Source Systems:

  • A folder is now displayed for each ODP context in the source system tree. Source systems for source ODP context are grouped in the relevant folder.
  • You can define whether or not a hierarchical grouping of data sources in the source should be added to the DataSource tree.
  • You can specify a background user for the source system. This is needed in order to check whether the BW system in the source is a unique subscriber. The reason for running this check is that the BW system that is not a unique subscriber for the source system can cause problems when source is copied.


        Data provisioning using operational data provisioning as an alternative to previous provisioning of DataSources from SAP source systems (using the

        service API) offers you the following advantages:

  • Communication between source and BW system and data transfer configuration are significantly simplified. Communication using synchronous RFC, ALE/IDocs is skipped and data transfer is not controlled using the qRFC outbound queue.
  • The operational data provisioning framework with the new (operational) delta queues takes over tasks and services that were previously covered by the Persistent Staging Area (PSA). The data transfer process (DTP) in particular can fetch data directly from the (operational) delta queues. This makes InfoPackages and loading using the PSA optional. PSA monitoring is triggered in this case by the delta queue monitor (transaction ODQMON).
  • Delta data of the application can be retained for a definable time period in the (operational) delta queue. The data can also be requested again during this time period by the DTP.
  • The operational data provisioning framework uses a standardized technology for different consumers of the source data (for example, BW and SAP Data Services).

19)  New Authorization Objects in class RS(extracted from Help.Sap)

  • S_RS_HCPR SAP HANA Composite Provider authorizations
  • RSHAAP authorizations for the SAP HANA analysis process
  • RSHAOT authorizations for SAP HANA analysis elements
  • S_RS_ODSV Open ODS view
  • S_RS_ODSP_H ODP: extraction from SAP HANA

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

Regards,

Prabhith

To report this post you need to login first.

14 Comments

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

  1. Jagan Peddamallu

    Hello,

    Thanks for Sharing Information and it is very help full to track all thins in single Tcode (RSA1).

    We are also having same version Where in the administration we are not seeing any House keeping Activities.Do we need to apply any note for this.

    Regards

    Jagan

    (0) 
  2. Amir Dror

    Hi,

    Very good blog!

    In 7.4 sp 6 when we try to create a new DSO we get the old screen and don’t have the option to create it above HANA model as you shoed in your document. Is there special note to apply for this?

    Thanks,

    Amir

    (0) 
  3. Roland Szajko

    Hi prabhith

    Point 15 should be removed, as the field based DSO-s will not be delivered, instad the Advanced DSO will be delivered.

    Delivery of the advanced DataStore object is scheduled for SAP BW Support

    Package 8 on HANA, which should incorporates the functions of the field based DSO-s.

    br

    Roland

    (0) 

Leave a Reply