How to remove Special Period from Prompt Range
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,