Skip to Content

privileges required for accessing virtual tables in sap bw 7.5

Feb 27 at 12:50 PM


avatar image

Hi All,

I am trying to create a Data Source in BW 7.5 on top of Virtual Tables.

I am creating virtual tables using SDA. I did not get any errors while creating virtual tables.

I created source system as well successfully able to see those virtual tables into BW.

But when i am creating Data Source or Open ODS view or any infoprovider i am getting activaton error as below:


I got privileges for SYS_REPO and _SYS_BI, _SYS_BIC and our own schemes as well.

but still i am getting error.

Kindly let me know what are all privileges needed to use those virtual tables in SAP BW 7.5.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Andras Margitics
Mar 05 at 10:58 AM

Hi Naresh,

Error is:

"error in bw:" "error when activating open ods view"

Necessary Privileges to check:

For creating remote sources, the system privilege CREATE REMOTE SOURCE is required.

For creating virtual tables, the object privilege CREATE VIRTUAL TABLE is required.

Also make sure you applied following notes in your system:

2177169 - CompositeProvider: Incompatible data types for input parameters of calculation views

2213662 - Open ODS view: Data type information for fields of an Open ODS view

2098505 - CompositeProvider: "Attribute engine failed" error for activation

Furthermore I would also recommend to apply below notes:

2254636 - Open ODS view: Missing data type information for fields of Open ODS view

2188567 - Open ODS view: Key information of source field with namespace incorrectly displayed

2243031 - Open ODS view: Exception when saving if type of association is selected but no object is entered

2259505 - Open ODS view: Runtime error for use of source fields of type 'Decimal' with decimal places as characteristic

2207685 - Open ODS view: Error for query with navigation attributes from Open ODS view with key of type DEC

Best regards, Andras

10 |10000 characters needed characters left characters exceeded