COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Blue on 14 Feb 2006 02:17:42 PM

Title: [Solved] What do Label and Query Item mean in Drill-Through def?
Post by: Blue on 14 Feb 2006 02:17:42 PM
G'day all

Please excuse my ignorance.Ã,  I am working with Cognos 8 BI and trying to create drill-throughs in Cognos Connection.Ã,  The documentation provided by Cognos on this product is not specific enough nor provides any examples.Ã,  I could not find any useful pages in the Knowledgebase either.Ã,  Actually NO pages are returned if I focus on Cognos 8 * using the string drill-through!

For the drill-through target I have a choice in the source type of "None", "Label", and "Query Item".Ã,  Using "None" causes the target AS view or CRN report to open without any filters.Ã, 

Can any explain to me what "Label" and "Query Item" mean please?

For CRN I am guessing the former is for column header and the latter is the column value.Ã,  Is this correct?
For AS I am at a loss.

TIA

Blue
Title: Re: What do Label and Query Item mean in Drill-Through def?
Post by: MFGF on 15 Feb 2006 04:57:33 AM
G'day Blue,

The Source Type you are referring to is specifically for bookmarks - it is specifying what you want to pass as a bookmark reference to the target report.  In this case the target report would have been created in Report Studio, and would have a bookmark defined within it.  This could have been defined as either a text bookmark, a data item value bookmark, a data item label bookmark, or a report expression (calculation) bookmark.  The drillthrough definition is simply allowing you to pass values in to match up to the bookmark - if you select None, no values are passed in, if you select Label, you get to type in some text which is then passed through, and if you select Query Item you select an item from the package whose data gets passed through.  This is just for bookmarks, though - nothing else.

For most drillthroughs, you will probably want to pass data to filter the target report rather than passing data to jump to a bookmark at a specific point in the output.  In this case, your target report would require a prompt filter for each value to be passed through (easy to do in Query Studio and Report Studio - in Analysis Studio the trick is to drag a member to the Context area, then right-click on it and select the "use as Go To Parameter" option).

When you now define drillthroughs to these reports, the parameters appear in the drillthrough definition and allow you to select query items from the package to pass in for them (use the pencil icon to the right of each parameter).

Hope that clears things up a little!

Best regards,

MF.
Title: Re: What do Label and Query Item mean in Drill-Through def?
Post by: Blue on 23 Feb 2006 10:58:22 AM
Thanks MF, that's a really good and concise explanation.  I wish Cognos could write its documentation in such language.