cancel
Showing results for 
Search instead for 
Did you mean: 

privileges required for accessing virtual tables in sap bw 7.5

former_member267852
Participant
0 Kudos

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:

virtual-tables-error.jpg

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.

Thanks,

Naresh.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Dear Naresh ,


Please can share the solution , or still you have the issue ??


Note : i have the same issue .


Best Regards,

Homsi

0 Kudos

can you please share the solution? im facing the same Problem.

Thank you 🙂

Former Member
0 Kudos

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