Skip to Content
0
Former Member
Nov 24, 2006 at 06:39 PM

F4 on Variable Screen for a DataStore Object Produces Long Run Time

108 Views

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?

Thanks!