Query execution taking long time....
I am facing a strange issue in SAP BW Bex side(Environment 7.3SP4).
I have a query where we are doing some YTD ,MTD calculations.
The prompt/variable is mandatory fiscal year period(Customer exit), by default current fical year period 002.2013 will be shown to user.
When I execute the query with prompt value as 001.2013(or any other periods except current period),output is coming in 3 seconds.
But when I execute the query with prompt 002.2013(current period), the result is not coming atall.
Can some body help with a suitable solution.
I have never faced such an issue before..
Golive date is reaching fast...so expecting some quick response..
Many thanks in Advance