Question:
Hi Gurus,
problem since 2 days: when I'm in a workbook and want to select a filter in the navigation block, the popup shows up. But then, I have to wait about 60-70 seconds, but sometimes more than 250 seconds. Not good, especially not because users are complaining.
In SM50, I see long time on SAPLRSDU_S. OSS suggested to do dbstatistics again, but no result. And now, OSS don't know it anymore.
Any suggestions?
Cheers!
Answer:
Hi! Is it a query on a multicube?
Answer:
Hi,
Filter can read F4 entries at master data table (few seconds), or can be read F4 entries at the cube (many seconds). If cube have many records and F4 list only shows values used in infocube. At that time you can see with SM50 that your process is making insert in a temporary table.
Only after selecting master data is used in the cube, the list is display.
The type of F4 processing is defined in the infoobject or in the WEB Template.
While you are waiting for F4 list, try to check if any table name appear on SM50. If so, it's possible that you need to change the F4 processing type.
I hope this helps
Pedro
Answer:
If you want further information on this you may want to look at the following notes:
581079, 581802, 626887
Essentially what SAP states is that the selection for posted values at the variable selection screen (and probably in general) is very inefficiant, and as such they recomend turning this off and just sticking w/ master data listing.
From what I read in these and releated notes they seem to hint at the idea that the efficiency of querying posted master data in the F4 screen can be improved and they might get around to doing it sometime.
- Stephen
Answer:
Hello,
thanks for input! I found transaction "smgw" and saw that the it is a gateway problem (menu: Jump -> Trace -> Gateway -> show file). Make your selection by day.