Overview
SAP Introduced new functionality from BW 7.4 on HANA where we can generate HANA view directly from B4HANA and BW on HANA 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 the 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 BW4HANA 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)
SAP encouraging to use inbuild FIORI URL for external Hana view configuration in BW4HANA.
External HANA View setup in BW4HANA Steps: –
- Take all system backup
- User sync and setup HANA user creation along with ABAP user
- External HANA view related TRANSACTION / FIORI URL
- Global Role for HANA external HANA view and Multi-Role
- Parameter setup for external HANA view setup
- Generate external HANA view with ADSO
- Sync new HANA user role from BW4HANA application
- Check external HANA view from Application and DB level
Take all system backup: –
As per preventive measures take full DB backup, We are only adding new configuration and no impact on system core functionality.
User sync and setup HANA user creation along with ABAP user :-
Same as
https://blogs.sap.com/2020/12/01/external-hana-view-configuration-in-bw-on-hana/
Global Role for HANA external HANA view
If you are using assignment type as D (Direct assignment), Need to create a global role. (More explanation under next setup)
bw2hana/<ABAP_Schema>_SAP_BW_MODEL_GENERATION is a master role and needs to create in every environment, Without this role, one can be 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.
External HANA view related TRANSACTION / FIORI URL:-
All transaction details added in previous blog, It’s a same as BW on HANA.
https://<hostname:https port>/sap/bc/ui2/flp?sap-client=<Client number>&sap-language=EN#Shell-home
Assign FIORI roles, SAP_BW4_MODELER, and SAP BW4 REPORTING USER roles to the user so that the user can access FIORI tails.
Under data Management Select external Hana view tail
Go to general settings
Based on SAP default setting need to give HANA package name as system-local.bw.bw2hana
It will allow the Application layer to create all external Hana views under system-local.bw package.
Check the entry in the RS2HANA_VIEW_SET table.
Changing an existing package is only possible if the HANA package is empty.
The below option can be checked based on functional requirements.
Assignment Type:- SAP provides 2 assignment types on BW4hana and based on your selection external Hana view roles will be created at the HANA DB level.
I preferred D direct assignment as it required only one global role and additional analytical privileges will generate based on infoprovider external Hana view.
If you will use Assignment M it will generate par BW4HANA DB user role, for example, if you have 2000 users it will generate 2000 roles as below format.
bw2hana/<ABAP_Schema>_SAP_BW_MODEL_GENERATION_username :- if assignment type is ‘M’
bw2hana/<ABAP_Schema>_SAP_BW_MODEL_GENERATION :- GLOBAL Role
We have 2 options in BW4hana for AP generation, S and U.
Multiple BW4HANA
If multiple BW4HANA systems share on HANA instance, it is mandatory to set a different package in each system.
Generate external HANA view with ADSO
For NW 7.5 SP7 all development supported by eclipse.
This step purely for the functional team, they can follow the below link and enable external HANA view from eclipse.
https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/2.0.2/en-US/6633d851345c4770bd4e523701b...
https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/2.0.3/en-US/65fc810abf0549ee861b0d2c7b7...
https://help.sap.com/viewer/04030263a0d041309a039fa3ea586720/7.5.3/en-US/8f244c00ee8f4abd888d7ca30f0...
Sync new HANA user role from BW4HANA application
Click on analytic privileges to remove and add HANA DB roles analytical privileges for specific BW4HANA objects.
The detailed analysis we can enable below expert mode settings: -
Check external HANA view from Application and DB level:-
Click on object name and click on check view consistency,
DB level check views on below location, All BW4HANA external HANA views will be created under the system-local package as we placed the parameter under RS2hana_admin.
Reference SAP Notes:-
2695442 - External Hana View: Activation of BW Object fails with error 'Replication failed RS2HANA_AUTH234'
https://wiki.scn.sap.com/wiki/display/BI/BW2HANA+Authorization+Generation
https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/2.0.4/en-US/6633d851345c4770bd4e523701b...
Advantages:-
- Allows access to BW4HANA data via SQL front ends.
- All applications that can read SAP HANA views can process the data easily for External views
- The advantage of running the query which is executed on the SAP HANA view retrieves the data directly from SAP HANA, without accessing the BW4HANA system at all.
- Data can be viewed by Excel and other tools via DB
I hope this document will help you with the external HANA view setup.
Cheers!
Anikesh Jyotishi