Suppress Zero for rows and columns
Environment: Cognos Report Studio 8.2, SQL Server Cube 2005 Suppress zero rows and columns for crosstab reports built in report studio over SQL server cube can be quite a bit of pain, due to the fact that there is no in-built suppression facility. You might be tempted to use the Suppression option from Query properties, but will be disappointed to know that it works only for SAP. So, in order to suppress the rows or columns you can use following. Solution: Assume that you are showing LOCATIONS on rows, and MONTHS on columns. Your measure is UNIT SOLD. This is the easiest example I can think of. You simply need to modify the rows and columns expression to below: filter([myCube].[Location].[Location Names],([myCube].[Measures].[Units Sold])>0) filter([myCube].[Date].[Months],([myCube].[Measures].[Units Sold])>0) So Cognos will populate the rows and columns with only those members whose 'Units Sold' is not zero. If your measure can have negative values too, for example: Rev...