COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gshilpa24 on 27 Sep 2010 04:39:09 AM

Title: Drill through
Post by: gshilpa24 on 27 Sep 2010 04:39:09 AM
Further to the probelm which i mentioned, i have another query regarding drill through.

i have (year-month) "year_month" data item  in x axis from 2008-06 to 2010-08 and it is  a drill through report.
when i run the report and keep the cursor on any of the bar in the chart is shows an drill through icon (hand icon ) . My requirement is i do not want the drill through icon to appear on the chart from 2008-06 to 2008-02.

Can this be possible
Please respond.

Thanks in Advance
Title: Re: Drill through
Post by: cognostechie on 27 Sep 2010 03:32:22 PM
You can disable drill-up/down from the Data Menu/Drill Behaviour.
Title: Re: Drill through
Post by: gshilpa24 on 28 Sep 2010 06:32:44 AM
Thanks for the response but the i do not have drill up/drill down behaviour here. It is just a drill through report.

I have a parameter created . Here it goes.

[current_Month]=?m?

Now i am passing this parameter in my main report. so my thought is i could write piece of code in this way in the filter expression.

CASE
WHEN
([Current_Month]>='2008-06' and
[Current_Month]<='2010-02')
THEN
NULL
ELSE
([Current_Month]=?m?)
END

but this is not working,

Anybody please provide yr inputs/suggestions.