doc-53210

Generated by Jive on 2014-09-23+02:001

SAP BW 7.4 Powered by HANA -- PromisingFeatures (Part 2)

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



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

http://scn.sap.com/docs/DOC-53205



SAP BW 7.4 Powered by HANA -- Promising Features (Part 2)


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

http://scn.sap.com/servlet/JiveServlet/showImage/102-53210-4-410192/1.png



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



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

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




b) Provide the Package and HANA Information model details:




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.

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

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



12) New House Keeping tasks added under Administration tab:




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:




New Version

Case 2:




Old Version New Version

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

http://scn.sap.com/servlet/JiveServlet/showImage/102-53210-4-410213/11a.png

http://scn.sap.com/servlet/JiveServlet/showImage/102-53210-4-410206/10+a.png



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

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.

17) Changes in RSDDB Screen.



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:

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

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

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




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 BWsystem that is not a unique subscriber for the source system can cause problems when source iscopied.

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 significantlysimplified. Communication using synchronous RFC, ALE/IDocs is skipped and data transfer is notcontrolled using the qRFC outbound queue.

• The operational data provisioning framework with the new (operational) delta queues takes overtasks and services that were previously covered by the Persistent Staging Area (PSA). The datatransfer process (DTP) in particular can fetch data directly from the (operational) delta queues. Thismakes InfoPackages and loading using the PSA optional. PSA monitoring is triggered in this case bythe delta queue monitor (transaction ODQMON).

• Delta data of the application can be retained for a definable time period in the (operational) deltaqueue. 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 consumersof 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

https://help.sap.com/saphelp_nw73/helpdata/en/cc/6fac0c0533461986b9127b90ea7bde/frameset.htm

https://help.sap.com/saphelp_nw73/helpdata/en/cc/6fac0c0533461986b9127b90ea7bde/frameset.htm

doc-53210

Documents