Skip to Content
0
Former Member
Nov 19, 2012 at 05:33 PM

Issue with the SAP variable 0S_BCSRQ

61 Views

Hi All,

Recently we had upgraded our BW environment to 7.3. While performing post upgrade checks we found an issue with our BCS reports. We have a virtual cube which gets data from BCS posting and a reporting cube which pull data from the virtual cube mentioned earlier. post upgrade all the reports were matchig with the BCS data. we had to realod the reporting cbue after that all amounts in our BCS reports built on the multi provider based on reporting & virtual cubes.

The reports built on this multi provider are such that the reporting cube is supposed to fetch all the closed requests for which delta has been fetched & the associated virtual cube should fetch only those requests which are not yet available for reporting in reporting cube i.e. open requests only. This is achieved through 2 variables 0S_BCSRQ (for open requests in BCS cube) & 0S_CSRQ (for requests available for reporting in reporting cube). Both of these
variables have been used in our query. The virtual cube is fetching all requests instead of fetching from the open request. Without the data coming in from virtual cube, the report output would match that from cube. The data in this case should not come from virtual cube as all the requests in underlying cube have been fetched.

Currently there are no open requests in our virtual BCS cube but the variable is behaving strangely. Did any one got similar issue with the variable 0S_BCSRQ. Wan't lucky to find any SAP notes on this variable. Please suggest on how to fix it.