Creating a context filter for a crosstab report using a dimensional data source in IBM Cognos Analytics V11.1.x involves filtering measure values without affecting the items in the rows and columns. Here is how it works:
Open Crosstab Report: Open the crosstab report in Cognos Analytics Report Studio.
Select Measure: Identify the measure you want to filter.
Add Context Filter: Apply the context filter to the measure. This filter will affect only the measure values and not the dimensional items in the rows and columns.
Filter Configuration: Configure the filter criteria as needed to refine the measure values displayed in the crosstab.
Using context filters in this manner allows for precise control over the data being analyzed without altering the structure of the crosstab.
[: IBM Cognos Analytics Report Studio User Guide, , ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit