Business Intelligence, Analytics and Cognos

If you want 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 Report Studio 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 2008. 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.

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...