Fiscal year perid (F4) value help is taking more time

[Former Member]

Hi experts,

i have used the fiscal year/period variable in the report.

once execute the report, first variable screen will appear.

for fiscal year/period variable, if you open value help, it will taking lot of time to open values.

if you enter value directly like 012.2008, there will be no problem.

only when click for value help it is taking lot of time.

This problem for only fiscalyear/period variable only.

Even i changed the different variabel for fiscalyear period, still have the problem.

remaining varaiblels in the report does not have any problem.

i have check the BWD and BWQ there is no problem, only have problem in the BWP.

all settings are same still have problem in the bwp.

is there any SID missing or any problem please let me know.

please help me on this problem.

thnaks in advance.

thanks

amith.

[Former Member]

If the settign in the query/infoobject properties is read infoprovider values rather than master data values in F4 help then whathappens is the SID table is not read - it runs a select distinct on the cube!!!