Enable filters in workspaces in Cognos Workspace

You can include a data item in the query of the report, but not show that data item in the actual report. This is useful for creating calculations and filters. If you want IBM® Cognos® Workspace users to filter content in a workspace based on a data item that is not visible in the report, you must include this data item in its own query and name it _BusinessInsight_ within the IBM Cognos Analytics - Reporting report. Therefore, the data item must exist in both the query used for the data container (such as the list, crosstab, or chart) and in this separate query.

For example, a chart shows the revenue for the product lines for each region. You want to filter the chart to show only data for the year 2012. When you author the report, in addition to including Year in the Query1 used for the chart data container, you create a new query named _BusinessInsight_ that includes Year.

Procedure

  1. Click the Queries icon Queries icon, and then click Queries.
  2. Click the Toolbox icon The toolbox icon, and drag a Query object to the work area.
  3. Click the Query object, click the Show properties icon Show properties icon, and in the Properties pane, in the Name box, type _BusinessInsight_.
  4. Double-click the Query object, click the Data icon Data icon, and from the Source tab source tab, add the data item to use as a filter.

    Ensure that the same data item also exists in the query used for the data container.