We experiencing a long run time in returning values when we select F4 for the Variable 0COMP_CODE when we process query for a DataStore. Before our upgrade to NW04S, we did not experience this issue. As background, the DataStore (ODS) has not changed, the variable has not changed, and the query has not changed.
0COMP_CODE has the following configuration in RSD1:
Query Def. Filter Value Selection Values in Master Data Table
Query Execution Filter Val. Selectn Only Posted Values for Navigation.
These settings are exactly like this in our BW 3.5 system.
In my review of the differences, I found that in BW 3.5, the runtime is short because the selection that is returned is the Company Codes in the Master Data table, but in NW04S, the selection that is returned is the Company Codes within the ODS.
Has anyone experienced this before and if so what was your resolution?