External HANA view configuration in BW on HANA

1. Overview

SAP Introduced new functionality after BW 7.4 on HANA where we can generate HANA view directly from BW application during BW object activation, The external HANA view enables to create scenarios where data, which is modeled in the BW system, are merged with data modeled in SAP HANA with SAP HANA tools.

This document will provide you an overview of external HANA view configuration from the SAP BASIS point of view.

DISCLAIMER

The content of this blog post is provided “AS IS”. This information could contain technical inaccuracies, typographical errors, and out-of-date information. This document may be updated or changed without notice at any time. Use of the information is therefore at your own risk. In no event shall SAP be liable for special, indirect, incidental, or consequential damages resulting from or related to the use of this document.

Purpose

This document tried to include all Basis steps for BW on HANA external HANA view configuration.

From BW 7.50 it is possible to generate Calculation Views for all objects if you execute the steps available (SAP note 2236064)

According to this note, it is necessary to add an entry into table RS2HANA_VIEW_SET.

External HANA View setup in BW on HANA Steps: –

◉ Take all system backup

◉ User sync and setup HANA user creation along with ABAP user

◉ External HANA view related TRANSACTION

◉ Global Role for HANA external HANA view

◉ Parameter setup for external HANA view setup

◉ Generate external HANA view with ODSO and ADSO

◉ Sync new HANA user role from BW application

◉ Check external HANA view at DB level

Take all system backup: –

As we are adding a new configuration as such no impact on the system, but as per preventive measure take full DB backup.

User sync and setup HANA user creation along with ABAP user

Maintain SM 30 USR_DBMS_SYSTEM Table/View value for enable DBMS tab in su01.

Provide DB connection name which needs to update in DBCO and provide productive client number.

It will enable the DBMS tab in su01 and you will able to created DB user from the ABAP system.

Note:-  ABAP and HANA DB user names should be the same.

TRANSACTION:-

In terms of SAP HANA external view configuration and check we must know about the below TCODEs.

1) RS2HANA_ADMIN: – Through this tcode we can perform all administration tasks and check all external HANA view configurations, even we can navigate all external HANA view transactions from this tcode.

2) RS2HANA_VIEW: – All external HANA view settings we can update by this tcode, we can say it’s a pre-requisite to set up all parameters here before stating External HANA view generation.

3) RS2HANA_CHECK: If we can face any issues during the generation of the external BW HANA view This tcode provides you with overall status.

4) RS2HANA_GEN: Sync all external HANA view role to HANA DB user.

Global Role for HANA external HANA view

bw2hana/<ABAP_Schema>_SAP_BW_MODEL_GENERATION is a master role and needs to create in every environment, Without this role on one can able to generate an external HANA view from the BW system, This role should be assigned to the HANA level.

To be able to access SAP HANA views that have been generated from the BW system, you need the following authorizations:

◉ Object privilege: SELECT on _SYS_BI

◉ Object privilege: EXECUTE on REPOSITORY_REST(SYS)

◉ Package privilege: REPO.READ on the content package where generated SAP HANA views are stored.

Parameter setup for external HANA view setup

Before you start to generate “external BW HANA view” it is necessary to think about some general settings e.g. which package should be used,

With 7.5 and support package 4 or higher you have the following options in transaction RS2HANA_VIEW.

SAP HANA Package:- system-local.bw.bw2hana (Check entry in RS2HANA_VIEW_SET table)

Assignment Type:-  SAP providing 3 assignment types and based on your selection external Hana view roles will be created at the HANA DB level.

HANA Package is ‘system-local.bw.bw2hana’ and can be checked in table RS2HANA_VIEW_SET or RS2HANA_VIEW.

Changing an existing package is only possible if the HANA package is empty.

Multiple BW System on one HANA

If multiple BW systems share on HANA instance, it is mandatory to set a different package in each system.

Generate external HANA view with ODSO and ADSO

This step purely for the functional team, they can follow the below link and enable external HANA view from RSA1.

https://help.sap.com/viewer/04030263a0d041309a039fa3ea586720/7.5.3/en-US/8550a8c268a940c39171a441abc01f56.html

https://help.sap.com/viewer/04030263a0d041309a039fa3ea586720/7.5.3/en-US/8f244c00ee8f4abd888d7ca30f0b0ce3.html

https://blogs.sap.com/2016/04/05/how-to-consume-sap-bw-objects-in-hana-studio/

Sync new HANA user role from BW application

RS2HANA_GEN:- You can sync all ABAP users with external HANA views authorizations at the DB level.

Provide BW object name and BW user name, Even you can select multiple users for one object or multiple objects.

It will assign the required role to HANA users and if required generate analytical privileges as per requirement.

Mass Generation of Authorizations

If you want to create an identical SAP HANA user for multiple BW users, you can use report RSUSR_DBMS_USERS for mass synchronization. For more information.

Check external HANA view at DB level

All BW external HANA views will be created under the system-local package as we placed the parameter under RS2HANA_VIEW TCODE.

Advantages:-

1.  Allows access to BW data via SQL front ends.

2. All applications that can read SAP HANA views can process the data easily for External views

3. The advantage of running the query which is executed on the SAP HANA view retrieves the data directly from SAP HANA, without accessing the BW system at all.