Often a multi-select prompt takes a lot of space in a cognos report. With the use of a multi-select-popup-prompt you can save some space and still keep all the functionality.
I found a URL with a complete example:
You want to build a report which shows salesdata per region and show every region on an new page.
Create a table with branch, year and some fact data.
Click once on the column branch.
In the toolbar click on Structure > Page-break (with Master/Detail)
After that you can also click on ‘Section’. This way you create an header per page for Region.
See Section in report for more enhancement details.
In Cognos you can use a lot of Dimensional functions. Information about these functions can be found on:
You can download a zip-file here witch contains a PDF and a zip-file with examples.
The dimensional functions can be used with crosstab reports with for example year, quarter and sales facts.
A usefull example can be found on Youtube:
You want to display a mini chart in the row of a crosstab.
Create a crosstab report with for example: Product-line, year and sales.
Go to the Query Explorer and rename Query1 to Crosstab.
Go to the Query Explorer and copy the Crosstab query. Then click paste and rename the query to Chart.
Create a line chart with the query Chart as source. Add year-month from the date dimension into the query.
From the query drag year-month into the X-axis Catagory. Then drag Sales into Y-axis Default measure.
Define a sort on the X-axis. Select the abc on the X-axis, go to the properties and choose NO for Visible. Select the Y-axis and go to the properties and choose NO for Visible. In the properties of the Chart set Hide for Legend.
Set the size of the graph to 70px (height) and 140px (width) in the Size&Overflow properties of the Chart.
Unlock all objects in the report.
Drag a table into the row with the productlines in the crosstab (1 row, 2 columns).
Drag and drop Product-line into the table. Choose align left for that field of the table.
Now drag the chart into the left field of the table.
Go to the properties of the chart and click on Master Detail Relationships. A propertie box opens. In here create a new link between Product-line from the Query Crosstab and Product-line from the query Chart.
Now run the report to see the result.