How does suppression work with DMR on CQM or DQM

Check list of all posts

(This document is excerpt from IBM article http://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/page529.html)

Overview

There are 4 cases listed below

Example #	Suppress Property	Model Ordering	Compatible Query Mode	Dynamic Query Mode
Case 1	None	None	Nulls suppressed	No suppression
Case 2	None	OLAP	No suppression	No suppression
Case 3	Nulls or (Default)	None	Nulls suppressed	Nulls suppressed
Case 4	Nulls or (Default)	OLAP	No suppression	Nulls suppressed

Suppress Property

pane of Report Studio with a property called Suppress that can have one of three states:

·         (Default), when the property value is not set, implying data-provider-dependent behaviour with respect to null suppression

·         None, implying that no values are suppressed from report output

·         Nulls, implying that null values are suppressed

In Compatible Query Mode, however, the Suppress query property is ignored for a report based on a DMR package.

Model Ordering