How to remove Special Period from Prompt Range

[Former Member]

Hi All,

I have made one webI report in which Fiscal Year/Period is in Range Prompt.

When I give prompt value like (001.2009 to 004.2010), I am getting data for following months 001.2009 to 012.2009, 013.2009, 014.2009,015.2009,016.2009, 001.2010 to 004.2010.

Now I don't want to see data for Special Periods (013.2009,014.2009,015.2009,016.2009).

How can i exclude this 13 to 16 periods from prompt range.

I have developed this report on top of BW Query.

Thanks & Regards,

Rishit Kamdar

[Former Member]

Hi Rohit,

Thanks for your help

I got the solution, but now if i don't want to see data for Special Period in Cross-tab then is there any function for that?

[Former Member]

Apply the filter at the report level or block (i.e. Cross tab in your case) level.

You can use the same variable that you created using Left() for creating the filter. or create a variable similar to second method

suggested in the earlier post and create a filter on it. Both the ways it should work.

Regards,

Rohit

Edited by: rohit12 on Apr 7, 2010 11:47 AM

[Former Member]

I used Left (Fiscal Year.period;3) and put this in If Loop and that's how i got solution.

[Former Member]

Hi Rishit,

If you have the Fiscal Period as a dimension in the BEx query then you can apply the filter at the BO query level, so that it will

always exclude the unwanted periods,

You can apply the filter at the report level to exclude the periods. Create an object as Substr([Cal period year];1;3). Now apply the filter to remove the data for periods 13, 14, 15 and 16.

Although not confident, but at the BEx query level creating an exit variable can solve the problem.

Regards,

Rohit