Skip to Content
May 02, 2013 at 06:49 AM

Query execution taking long time....


Hi All,

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 expecting some quick response..

Many thanks in Advance