Selection in one widget filtering other widgets

[dzwonitzer]

It appears that this is not possible in Workspace, but am looking for confirmation or alternatives.  I need the ability to display a visual component, like a chart and another widget.  Selection of a value / bar / point in the chart needs to filter the other widget, without changing the chart.  I can't figure out how to get selection to set the value of a parameter, which would filter the other widget. 

The closest that I can get is Drill Up/Down with a dimensional model, however that affects the original widget, drill down.  I don't want the original chart to be affected.   Defining a drill through on the chart causes a new window to open with the RS report, rather than affecting the workspace.  I know that I can use a prompt to achieve this, but my requirement is that chart effectively is the prompt.

Is this possible? 

[MFGF]

It appears that this is not possible in Workspace, but am looking for confirmation or alternatives.  I need the ability to display a visual component, like a chart and another widget.  Selection of a value / bar / point in the chart needs to filter the other widget, without changing the chart.  I can't figure out how to get selection to set the value of a parameter, which would filter the other widget. 

The closest that I can get is Drill Up/Down with a dimensional model, however that affects the original widget, drill down.  I don't want the original chart to be affected.   Defining a drill through on the chart causes a new window to open with the RS report, rather than affecting the workspace.  I know that I can use a prompt to achieve this, but my requirement is that chart effectively is the prompt.

Is this possible?

Not as far as I'm aware. Sorry.

MF.

[briancole]

I had the same issue recently. In order to get around this, you need to abandon Cognos Workspaces and create a Report Studio report and use Javascript:


1. Create a chart pointing at a query (Query 1)
2. Create a list pointing at a different query (Query 2)
3. Filter Query 2 by an optional parameter (Parameter 1)
4. Use Javascript to capture what the user has clicked upon in the chart
5. Populate a prompt box on the report linked to a parameter (Parameter 1)
6. Use Javascript to submit the prompt
7. Query 2 then filters by the parameter. Happy days 8)

CognosPaul has an example half-way down this page which incorporates the JS for determining what a user has hovered over and filters a list report accordingly:

http://www.performanceg2.com/blog/cognos-popups-hover/

I have recently implemented something similar, but it is not a straightforward task unfortunately  :-\ The report must be self-contained within Report Studio as none of the Javascript will work if you embed the finished Report Studio report into a Workspace as elements appear to be referenced differently in a Workspace.

[dzwonitzer]

I appreciate the feedback.  I opened a support case with IBM and they confirmed that this is not possible.  I have submitted an enhancement request to include this capability in the future.