The Cognos Report Toolkit - Place data item anywhere for list report

Check list of all posts

General note about The Cognos Report Toolkit

Report specification:  Relational, DMR, and Cube

Requirement

It is requested to put data item as below

Layout

In the column body, you can make any layout you want, then drag list item into defined place. This technique is very useful when there is chart with its associated items.

Background is very effective way to make report attractive.

To get it right, a Block contains data item must be defined, and size must be defined as well. In addition, we need to make sure that size must be big enough to host the text. Otherwise, you will see following display.

Relational Query

• Year: [Sales (query)].[Time].[Year]
• Americas Revenue: if ([Sales (query)].[Retailers].[Region] ='Americas') then ( [Sales (query)].[Sales].[Revenue]) else (0)
• Asia Pacific Revenue: if ([Sales (query)].[Retailers].[Region] ='Asia Pacific') then ( [Sales (query)].[Sales].[Revenue]) else (0)
• Europe Revenue: if ([Sales (query)].[Retailers].[Region] in ('Central Europe','Northern Europe','Southern Europe')) then ( [Sales (query)].[Sales].[Revenue]) else (0)
• All Revenue: [Sales (query)].[Sales].[Revenue]

DMR Query

• Year: [Sales (analysis)].[Time].[Time].[Year]
• Americas Revenue: tuple ([All Revenue],[Sales (analysis)].[Retailers].[Retailers].[Region]->[Retailers].[710])
• Asia Pacific Revenue: tuple ([All Revenue],[Sales (analysis)].[Retailers].[Retailers].[Region]->[Retailers].[740])
• Europe Revenue: tuple ([All Revenue],[Sales (analysis)].[Retailers].[Retailers].[Region]->[Retailers].[750]) + tuple ([All Revenue],[Sales (analysis)].[Retailers].[Retailers].[Region]->[Retailers].[760]) + tuple ([All Revenue],[Sales (analysis)].[Retailers].[Retailers].[Region]->[Retailers].[770])
• All Revenue: [Sales (Analysis)].[Sales].[Revenue]
• Filter: caption([Sales (analysis)].[Time].[Time].[Year]) in ('2012','2013')

Cube Query

• Year: filter([great_outdoors_sales_en].[Years].[Years].[Year],[All Revenue]>0)
• Americas Revenue: tuple ([All Revenue],[great_outdoors_sales_en].[Sales regions].[Sales regions].[Sales region]->:[PC].[@MEMBER].[710])
• Asia Pacific Revenue: tuple ([All Revenue],[great_outdoors_sales_en].[Sales regions].[Sales regions].[Sales region]->:[PC].[@MEMBER].[740])
• Europe Revenue: tuple ([All Revenue],[Sales (analysis)].[Retailers].[Retailers].[Region]->[Retailers].[750]) + tuple ([All Revenue],[Sales (analysis)].[Retailers].[Retailers].[Region]->[Retailers].[760]) + tuple ([All Revenue],[Sales (analysis)].[Retailers].[Retailers].[Region]->[Retailers].[770])
• All Revenue: [great_outdoors_sales_en].[Measures].[Revenue]