Skip to Content

privileges required for accessing virtual tables in sap bw 7.5

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10 at 01:16 PM

    Dear Naresh ,


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


    Note : i have the same issue .


    Best Regards,

    Homsi

    Add comment
    10|10000 characters needed characters exceeded