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