Creating reports for grid questions

Professional > Data management scripting > Publishing data > Cognos Framework Manager models > Building simple reports in Cognos Report Studio > Creating reports for grid questions

This section discusses various methods for creating reports for grid questions, that are based on Museum data that has been published via UNICOM Intelligence. The section covers many of the standard crosstabs that are commonly used in Market Research (which typically differ than crosstabs that are used in other business intelligence reporting). This section assumes basic Cognos Report Studio knowledge.

To create a grid question report

The following examples demonstrate building and customizing grid question reports that a based on the UNICOM Intelligence Museum sample.

1 In Cognos Report Studio, select the published UNICOM Intelligence Museum package.

2 Create a new report using a crosstab, by either selecting Crosstab on the first screen or from the toolbox.

3 In the Insertable Objects pane, select PresentationView Rating Dimensions.

4 In Page Explorer, add the following Dimensions items:

▪Add Column as a top dimension.

▪Add LevelID as a side dimension.

▪Select Serial as the measure.

5 In Query Explorer, open Rating.Column and create a filter that removes records with null responses:

[Column] is not null

6 Control the sort order by selecting Query1 in Query Explorer.

▪Expand the Codes folder under the Rating folder and drag Column.Index and LevelID.Index into the Query1 item in the Query Explorer pane.

▪Switch to Page Explorer and select Data Sort Edit Layout Sorting. This displays the Sorting dialog.

▪Add Column.Index and LevelID.Index to the Sort list, click the sort button, and then click OK.

Result

The report is rendered as:

Serial	Not at all interested (1)	Not particularly interested (2)	No opinion (3)	Slightly interested (4)	Very interested (5)	NA (Auto Created)
Dinosaurs	10	1	27	113	107	40
Conservation	3	2	7	30	14	242
Fish and reptiles	6	5	28	45	27	187
Fossils	6	1	15	25	18	233
Birds	9	8	18	32	27	204
Insects	13	2	18	27	19	219
Whales	2		14	28	38	216
Mammals	4	3	26	55	50	160
Minerals	13	6	14	25	28	212
Ecology	3		5	10	10	270
Botany	11	3	13	14	14	243
Origin of species	4	4	16	29	49	196
Human biology	4	5	17	34	63	175
Evolution	12	2	18	41	44	181
Wildlife in danger		1	2	16	13	266
Other						298

To filter the NA (Auto Created) column

In Query Explorer, create a Details Filter with the following expression:

[Column] is not null AND [Column] <> 'NA (Auto Created)'