If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill through

Started by gshilpa24, 27 Sep 2010 04:39:09 AM

Previous topic - Next topic

gshilpa24

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

cognostechie

You can disable drill-up/down from the Data Menu/Drill Behaviour.

gshilpa24

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.