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 from chart to list

Started by phoenixfire, 02 Jun 2009 06:14:43 PM

Previous topic - Next topic

phoenixfire

Hello,
I am trying to drill-through from a chart to a list in Report Studio 8.1.
I can setup the drill-through but for some reason, the parameters from chart are not passed to the list. Instead of using these passed parameters, the list prompts me again.
Any idea why this is happening?
Any help is appreciated.

cschnu

Did you set your drill through definitions to pass either a data item or a parameter?

CognosPaul

If the items being passed aren't displayed in the chart (keys for instance), make sure that they are checked off in the properties list.

phoenixfire

Yes I have setup the drill through to pass the data items to the list.

How do I check these passed data items in the chart? The only was I know is to associate the whole page with that query and then click on properties - check the data items that are passed.
Is this how you mean?

Thanks for the tips.

CognosPaul

When Cognos generates the SQL for any object, it only generates the items in the SQL necessary to render the object. If you attempt to do a drill-through based on an item that's not being included in the SQL, Cognos will just ignore that parameter.

Click on the chart node member in the chart. In the properties window you should see an option called "Properties". This window allows you to force certain items to be included in the generated SQL.

phoenixfire

PaulM,
Thanks a lot..that worked!!!
Never worked with charts much before..this really helps...
thanks again.

Cognos91

I am trying to drill-through from a chart to a list report, but in CA 11.0.7 version. I am unable to view the properties for a given chart node member.