Error while creating Open ODS View

[Former Member]

Hi,

Scenario is BW 7.5 system with HANA sp08.

I am trying to create a Open ODS view on HANA Studio using BW modeling tools. Source of this OODS is HANA table.

While checking I am not getting any errors, but while activating I am getting the below errors.

column store error: fail to create scenario: column store error: fail to create scenario: EC:2048"column store error: fail to create scenario:  [2950] user is not authorized" Error 2.048 has occurred in the BWA/SAP HANA server Error in BW ODS View Error when activating Open ODS View Unable to create CalculationScenario

It says user is not authorized. I have full access levels in my BW system. not sure which authorizations are missing. Any specific authorizations needs to be added in HANA Studio?  I am using the admin authorizations in HANA Studio too..

Regards,

Vishnu

[muthuram_shanmugavel2]

Hi,

Please check this thread -->

Solution:

Assume "DATA_BODS" is External schema and

We have to create Open ODS Views on top of Tables from "DATA_BODS" schema.

Standard HANA DB User for BW application will be SAP<SID>. Assume User is "SAPH01"

The point is that "SAPH01" user need select and Execute access for "DATA_BODS" schema.

So Open ODS View on top of the tables from schema can be activated successfully.

Execute the following SQL Queries using User, who is Owner of the schema"DATA_BODS".

GRANT SELECT ON SCHEMA DATA_BODS TO SAPH01 WITH GRANT OPTION

GRANT EXECUTE ON SCHEMA DATA_BODS TO SAPH01 WITH GRANT OPTION

Open ODS will be activated successfully.

Regards,

Muthuram