Hello
I have a huge report to do, containing 20 lists. The measures are the same, but the columns on wich figures must be aggregated are different.
I can have all informations with one request, but if I do that, when I create a list, the lines are duplicated for all values of the other columns not included in the list.
Ex. : I want a list with CA for companies/county and another list with CA for companies/product family. I create a request with Companies, product family, county and CA :
Company fAmily County CA
100 A C1 10
100 B C1 10
100 C C2 10
101 A C2 10
101 B C1 10
101 D C2 10
The first list gives :
Company County CA
100 C1 10
C1 10
C2 10
101 C2 10
C2 10
C1 10
But I want
Company County CA
100 C1 20
C2 10
101 C2 20
C1 10
Same problem when I remplace County with Family...
I used a request and others with tabular links, I used levels in dimensions, I used aggregate properties on everythings I can but I never manage to do want I want. Would I be obliged to make 20 request ???? :'(
Thanks a lot
Delphine
Hi,
This was one of the features in ReportNet. The fact that your query contains the Family item means that this is always retrieved, even though it is not displayed in the list.
The behaviour changed in Cognos 8 so that items in the query not being utilised in the list are ignored by default.
This probably doesn't help your quest for a single-query report, but explains the behaviour you are seeing.
MF.