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

Bar Chart - Pass Non-Series Parameter to Drill-Thru

Started by uidancer1, 26 Apr 2012 05:28:47 PM

Previous topic - Next topic

uidancer1

I have a bar chart that shows a count (y-axis) by Category Type (series) and Month/Year (x-axis). The chart is filtered by Location. I am trying to pass the parameters Category Type, Month/Year, AND Location to a drill-thru report upon clicking a specific bar. Since Location is only a filter and is not actually displayed in my chart, it will not pass.

Note: I am actually using this chart in Business Insight so it is not as simple as passing Location as a parameter instead of a data item.

MFGF

You will need to bring Location in as an item in your chart query in order to be able to pass it as a data item. I imagine you already have it in a _BusinessInsight_ query if you are filtering on it within Business Insight?

Regards,

MF.
Meep!

uidancer1

I figured out the issue. I did have Location in my query but because it was not actually in the chart object, it would not pass. I had to click on the Series value within the chart and in the Properties pane on the left side I clicked Data -> Properties. I then checked the box for the attribute I wanted to include in the chart (Location).
Thanks!