BEx Filter Navigation

[Former Member]

Hello All,

I am on BW 3.5. I have 0PROFIT_CTR in one of my BEx reports. In a single day, the first time a user right-clicks to select filter value, the available values take a VERY long time (10 minutes) to populate the filter box. However, after that first time, for the rest of the day, it pops right up in under a second.

Can anyone explain this behavior, and is there something I can pre-run to generate this ahead of time so my first user doesn't have to wait?

Dave Knudson

[Former Member]

Hi,

i guess you have this behaviour, because system keep the values in cache so next time it loaded from cache wich is more faster.

you can try to tune this, in tcode rsa1 0PROFIT_CTR management, Business explorer tab, set "Query def filter ..." to "only values in inforprovider".

Hope it helps