How to Improve the performance in Variable Selection Screen.

[Former Member]

Hi,

In Query Level we have Variable " User entry Defalt Valu". User want select particular value when he press "F4" it's take hours time how to improve the performance in Varaible Selection Screen.

Thanks in Advance.

Regards,

Venkat.

[former_member188080]

Hi Venkat,

It should be from master data table and not the one which mentioned above..

Your issue will get resolved..

also check BIA in case query is not accessing BIA and if it is available..

Thanks and regards

Kiran

[sukdev_koner2]

Dear Venkat.

You please try the following steps:

1. Say the InfoObject is 0EMPLOYEE against which you have created the variable, which user is trying to select value against, when they execute the report.

2. Goto RSA1-> InfoObject tab-> Select InfoObject 0EMPLOYEE.

3. Selcet the following options:

Query Execution Filter Val. Selectn - 'Only Posted Value for Navigation'

Filter Value Repr. At Query Exec. - 'Selector Box Without Values'

Please let me know if there is any more issue. Feel free to raise further concern

Thnx,

Sukdev K

[Former Member]

Hi Sukdev,

Thanks,

But we tried before only this option but it's not improve anything please let me know any other solution.

Regards,

Venkat.

[sukdev_koner2]

Venkat,

Please give me the other details- like - which is the infoobject for which its giving the 'F4' issue, what are the other variables in the same query, and what is the selection values user is giving while running the report etc...?

Thnx,

Sukdev Koner