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?
Quote from: dzwonitzer on 10 Jun 2014 08:38:38 AM
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.
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/ (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.
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.