Professional > Data management scripting > Publishing data > Cognos Framework Manager models > Building simple reports in Cognos Report Studio > Creating reports for loop questions > Creating a report that is based on the Household level
 
Creating a report that is based on the Household level
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 person tvdays Dimensions.
4 In Page Explorer, add the following Dimensions items:
▪Add LevelID as a top dimension.
▪Add Column as a side dimension.
▪Select Serial as the measure.
5 In Query Explorer, open 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.
7 Create summary rows and columns in Page Explorer by selecting <#LevelID#> from the table and adding a summary row via the Data menu: Data Summarize Automatic Summary. Perform the same step for <#Column#>.
Report specification
Serial
<#LevelID#>
Summary
<#Column#>
<#1234#>
<#1234#>
Summary
<#1234#>
<#1234#>
Result
The report is rendered as:
Serial
Channel 1
Channel 2
Channel 3
Channel 4
Channel 5
Summary
Didn't watch this channel last week
3
3
4
4
5
7
1-2 days
5
3
2
1
1
6
3-4 days
2
3
3
2
3
7
5-6 days
4
2
3
2
 
7
Every day
4
4
3
3
3
5
Summary
9
9
9
8
7
9
See also
Building simple reports in Cognos Report Studio