0PS_R10 Cube is a Virtual Cube based uses Direct Access DTP to read the data from ECC.

0PS_R10.PNG

This cube has a mandatory field Database Profile 0PS_PROFDB (PROF_DB) from ECC.

PS_R10_DB_Profile.PNG

While Querying the data from the Cube we have to input the selection without which it won’t select any data from ECC.

Since this is Direct Access DTP, we cannot restrict in DTP .

Options to restrict the data:

1) Cube Selection.

2) Query Filters

Otherwise you will get an Error as

E010(OK) : No database profile in overall profile for Info System Exists.

Error in Substep

Error Reading the data of Infoprovider 0PS_R10.

The Error and SAP message number are misleading.

0PS_R10_Error.PNG


Since we don’t have any reference documents I am creating Blog.

Thank you for Reading this blog.

To report this post you need to login first.

2 Comments

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

  1. sreenivas ch

    Dear Friend,

    I struck to execute the PS standard queries. One of the difficulty is the above error. query level i restricted with db profile standard value, still facing the error. while loading data mandatory filed db profile we loaded data perfectly, remote cube dtp execute tab is disable, manage db profile given standard structure still facing the above error.. please suggest

    regards,
    Sreeni

    (0) 

Leave a Reply