I have a webi report where in the data is coming from BEX query. The functionality is like user enters a date in date prompt in webi then the report should show next 12 months data from the key date. But the thing is if user enters say Sep 2011 then it should not show Jan 2012-Aug 2012 data as it falls in next year,it should only show Sep 2011 to Dec 2011 . But if user enters Jan 2011 then it should show Jan2011 - Dec 2011 Data. Hence I had to create 12 key figures in BEX queries. But I need to hide colums if they fall in next year.
BO XI 3.1