COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: SanderH on 25 Oct 2011 04:27:05 AM

Title: Singletons and page layers / context filters
Post by: SanderH on 25 Oct 2011 04:27:05 AM
Hi,

In v8.3 I want to create a report like shown below:

(http://www.sanderhovestad.nl/cognosbi.JPG)

It should show, for each of the elements in the page layers, a couple of main KPI's (e.g. Sales, Margin, Headcount) at the top followed by a crosstab with the details.

The crosstab is not a problem, but the KPI's are. I tried to use singleton's and intersections but they are not taking the page layers or even making it impossible to use page layers at all.

Anyone got a clue to help me out here?

Regards
Sander