Good Day !!!!!! 🙂
Problem Statement – Open ODS View Authorization Error:
When we create ODS View on top of tables from external schema,
We might face “Insufficient Privilege” (Error: Fail to create scenario:  User is not authorized) error during activation.
In this blog, I have explained the cause and solution for this issue with one example.
Assume BW application (DW1) is running on HANA database (HD1).
From BW view,
“SAPDW1” schema will be considered as SAP BW schema and
“HDBUSER_1” schema (native HANA DB schema) will be considered as external schema.
The version of the systems, which I used for below example.
BW: 7.40 SP11
HANA: 1.0 SP10
Eclipse Modelling Tools: 1.13.3
Open ODS View Creation:
I am going to create ODS View “ZMS_ODS” on top of table “SALES” which is from “HDBUSER_1” schema.
1. In eclipse, modelling perspective, connect SAP HANA system.
2. Navigate to “BW Modelling Tools” perspective and connect SAP BW system.
3. From BW system, attach SAP HANA system
4. Then create ODS View from BW system.
Select “Semantics Type” as Facts
Select “Source Type” as Database Table or View
Type “DB Object” as HDBUSER_1
Type “DB Object Name” as SALES and
5. Select “CUSTOMER_ID” and “PRODUCT_ID” as “Key Fields” and
Select “ACTUAL_SALES” as “Key Figure”.
Check field properties (description, aggregation…), then activate the ODS View.
Activation of ODS View will throw the error.
“column store error: fail to create scenario  user is not authorized”
Cause and Solution:
ODS View is BW object and It will interact with HANA DB using SAP<SID> user.
So, If we create ODS view on top of external table,
SELECT privilege on this external table should be granted to SAP<SID> user.
Our case, select privilege on “HDBUSER_1″.”SALES” (external table) should be granted to “SAPDW1” (BW user).
The below SQL has to be executed to solve ODS View authorization issue.
GRANT SELECT ON SCHEMA “HDBUSER_1” TO “SAPDW1”
After required privileges granted to BW user, Open ODS View is activated successfully.
created ODS view screenshot from “Eclipse Modelling Tools” and “SAP Logon GUI” have been attached below.
Data Preview of ODS View:
I checked the ODS View data from SAP BW system. It shows the data correctly.