Reading data from Virtual Cube 0PS_R10
0PS_R10 Cube is a Virtual Cube based uses Direct Access DTP to read the data from ECC.
This cube has a mandatory field Database Profile 0PS_PROFDB (PROF_DB) from ECC.
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.
Since we don’t have any reference documents I am creating Blog.
Thank you for Reading this blog.
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
can you share the error ?