Skip to Content

Hi All,

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: [2950] User is not authorized) error during activation. 

In this blog, I have explained the cause and solution for this issue with one example.



System Details:


Assume BW application (DW1) is running on HANA database (HD1).

temp.PNG

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.

System Version:

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.


Steps:


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

     Click “Finish”

      temp.PNG


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.

     temp.PNG

Problem Description:

Activation of ODS View will throw the error.

“column store error: fail to create scenario [2950] user is not authorized”

temp.PNG

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.

temp.PNG

Eclipse Modelling Tools SAP Logon GUI
temp.PNG temp.PNG

Data Preview of ODS View:

I checked the ODS View data from SAP BW system. It shows the data correctly.

SAP HANA: Table (“HDBUSER_1″.”SALES”) SAP BW: Open ODS View (ZMS_ODS)
temp.PNG

temp.PNG

Best Regards,

Muthuram

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply