Bex report issue - no applicable data found when we drill down on free char

[Former Member]

Hi All,

We are facing some strange issue with one of the report.

when user run the report for a week (02/02/2009 - 02/08/2009) and then drill down on particular char its working fine (first time).after that when he is trying to change and execute the report for other week on the same instence ( 02/09/2008 - 02/15/2009) by clicking on refresh and passing new values to the variable its showing up correctly at the time of drill down on free char its showing as *no applicable data found.*

when he logoff the system completey and run the report for the week( 02/09/2008 - 02/15/2009) values it is showing up with values even tough he drill down on free char.

issue basically when he was trying to drill on free char by chaging different date values in the same instance by clicking on refreh and by entering diffrent values its showing up as not applicable data found.

but when he enters the values for different weeks each time by closing the system and relogin report is working fine and showing up data eventough he drill down on free char.

Please help me out!

[Former Member]

Dear

Please check if any condition or exception you have created for that query.

Or still problem exists check SP level.

Regds,

Sachin J

[Former Member]

Hi,

There are no conditions and exceptions. we are in latest patch level 15(nw 2004's)