The Cognos Report Toolkit

Check list of all posts

All report samples below are generated with three different data sources, or relational, DMR and Cube. They are developed by Cognos version 10.2, with sample SQL server databases and power cube. Packages GO Sales (query), GO Sales (analysis) and great_outdoors_sales_en are used for relational, DMR and cube, respectively.  great_outdoors_sales_en is generated when creating data source for cube great_outdoors_sales_en.mdc, provided by IBM sample.

1 List Report

1.1 List report: Group column headers

1.2 List report: Make summary rows at the top

1.3 List report: Place data item anywhere

2 Crosstab

2.1 Crosstab: Make summary on the top

2.2 Crosstab: Make crosstab header look like list column headers

2.3 Crosstab: Make crosstab with multiple measures

2.4 Crosstab: Flatten hierarchy for crosstab nodes

2.5 Crosstab: Conditional drill

2.4 Crosstab: Stitch multiple crosstabs together

3.4 Chart: Top N + others Chart

3.4 Chart: Align series data with axis categories in chart

5.3 Page: Combine the Layout component reference and Prompt token macro