Detail Filter May Return Incorrect Results

Product(s) Affected

• Cognos 8 Business Intelligence Server 8.1.2 MR2

This issue affects specific queries against OLAP⁽¹⁾ and Dimensionally Modeled Relational⁽²⁾ (DMR) data sources authored in Report Studio only. It does not affect Analysis Studio or Query Studio reports.

 

Description

Detail filters on measures may be applied incorrectly to crosstabs or charts with multiple member sets on an edge resulting in incorrect data.

This problem only applies where the crosstab or chart has more than one member sets from different hierarchies on the same edge.

For example⁽³⁾ given this crosstab report with member sets of Year and Quarters on the row edge:

 

Applying the detail filter [Quantity sold] >= 10000 will correctly remove all cell values less than 10,000:

 

This is correct behavior. The filter causes the correct cell values for Months to be removed from the report.

Were we to use members set from different hierarchies, we will see incorrect behavior.

For example, consider this report where the edge items Year and Order method come from different hierarchies.

 

Applying the filter [Quantity sold] >= 10000 will incorrectly remove the Order method Special which has cell values greater than 10000:

 

Suggested Action

OLAP Data Sources

To minimize the potential of a data integrity problem, we strongly recommend that you apply hot site correction for Product Issue 538299. See Available Downloads below

Dimensionally Modeled Relational Data Sources

To minimize the potential of a data integrity problem, we strongly recommend that you apply hot site correction for Product Issue 540307. See Available Downloads below.

 

Suggested Workaround

None

Failure to follow these important recommendations may result in incorrect data returned. Cognos will not be liable for any loss or damages arising from the failure to implement these recommended directions.