Hi,
is it possible to run the report using Workspace Advanced to include both a chart object and a list object, but where the data for both of these objects is filtered by a single prompt for a field that exists in both objects on the report?
A simple example is a single report that includes both chart and list. The list shows products info and is filtered by prompt (product line) whenever the report is run. If I add a chart object to the same report, then if I drag the same fields of data that I used in the list object onto the chart object I can get a visualization with same data. However, instead of having same product line prompts two different times (one for each report object on the report), I need to use only single promt.
Is there any way to achieve this in Work space Advanced?
Thanks
Quote from: Thanay on 16 Apr 2015 03:26:04 AM
Hi,
is it possible to run the report using Workspace Advanced to include both a chart object and a list object, but where the data for both of these objects is filtered by a single prompt for a field that exists in both objects on the report?
A simple example is a single report that includes both chart and list. The list shows products info and is filtered by prompt (product line) whenever the report is run. If I add a chart object to the same report, then if I drag the same fields of data that I used in the list object onto the chart object I can get a visualization with same data. However, instead of having same product line prompts two different times (one for each report object on the report), I need to use only single promt.
Is there any way to achieve this in Work space Advanced?
Thanks
Hi,
Your choices here are either to:
a. Use Report Studio to modify the report so that both the list and the chart use the same query
b. Remove the prompt(s), Drag both the list and the chart into a Cognos Workspace and use a Cognos Workspace Select Values filter to filter both the list and the chart in the workspace.
c. Upgrade to Cognos BI 10.2.2 and get your administrator to create a new profile for Cognos Workspace Advanced that includes the ability to see and modify queries.
Cheers!
MF.
Quote from: MFGF on 16 Apr 2015 06:16:57 AM
Hi,
Your choices here are either to:
a. Use Report Studio to modify the report so that both the list and the chart use the same query
b. Remove the prompt(s), Drag both the list and the chart into a Cognos Workspace and use a Cognos Workspace Select Values filter to filter both the list and the chart in the workspace.
c. Upgrade to Cognos BI 10.2.2 and get your administrator to create a new profile for Cognos Workspace Advanced that includes the ability to see and modify queries.
Cheers!
MF.
Hi MFGF,
Thanks for your reply.
we are using cognos 10.2.2. could you please give the steps to create a new profile for Workspace Advanced to see the queries.
Thanks.
Quote from: Thanay on 16 Apr 2015 07:33:59 AM
Hi MFGF,
Thanks for your reply.
we are using cognos 10.2.2. could you please give the steps to create a new profile for Workspace Advanced to see the queries.
Thanks.
Hi,
Take a look at the Administration and Security Guide, Chapter 28 (Resource library) and the section titled ""Custom user interface profiles" on page 441
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_cra.pdf
Cheers!
MF.
I've got this working - we have our filters widget separate from the crosstab widget and the chart widget (could maybe combine them though).
The filters widget is written in RS, using the much better looking value promts. We then apply a detail filter (not a context filter) to each of the widgets, and tell the filter to prompt for values. The names must match.
We then bring it all together in Cognos Workspace and the filters work across multiple widgets.