COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Business Insight Advanced / Cognos Workspace Advanced => Topic started by: andy_mason_84 on 23 Oct 2014 10:15:59 AM

Title: Context Filter Not Passed in Drill Through
Post by: andy_mason_84 on 23 Oct 2014 10:15:59 AM
Hi All,

So we have a Workspace Advanced (WSA) cross tab with Products in Rows and Supplier Type in Columns.

We then put a Company in the Context filter and run the report in HTML.

Then right click on the figure and Go To - and then drill through to the target report via a drill through definition that has been set up for all 3 dimensions.

The only parameters that are passed are the ones in the body of the cross tab.

The Drill through ignores what is in the Context Filter.

Can anyone shed any light on what is going on here?

Surely this cannot be the expected behaviour.

We are on Cognos 10.2.1.1 and the reports are built using dimensional data.

Thanks,

Andy
Title: Re: Context Filter Not Passed in Drill Through
Post by: AM on 27 Apr 2015 05:29:44 PM
Seems this isn't supported

http://www-01.ibm.com/support/docview.wss?uid=swg21511919
Title: Re: Context Filter Not Passed in Drill Through
Post by: bdbits on 27 Apr 2015 06:02:07 PM
I know, right? You'd think it would just be another parameter passed through, but nooo.

I love drill-through definition functionality, but support of context filters in general is poor when it comes to drilling to another report, and not just in WSA.

You may want to log a support ticket and ask for this as an enhancement. The more people complain about it, the more likely they are to do something about it in the next release.
Title: Re: Context Filter Not Passed in Drill Through
Post by: maxchuie on 14 Dec 2015 07:29:31 AM
Is this supported for 10.2.2 version?
Title: Re: Context Filter Not Passed in Drill Through
Post by: MFGF on 14 Dec 2015 10:56:25 AM
Quote from: maxchuie on 14 Dec 2015 07:29:31 AM
Is this supported for 10.2.2 version?

No. Sadly not.

MF.
Title: Re: Context Filter Not Passed in Drill Through
Post by: maxchuie on 15 Dec 2015 08:33:46 AM
will it work in package level drill through?
context filters and row variables placed interactively on my report passed to constrain results on the go to reports(Package Level Drill Through)

1. how would you determine what attributes the user will use ( do i need a condition hide/show each attribute on the package level drill through report?)
2. will i need to make a filter (promptmany) for each and every attribute?

  is this even possible?