If you are unable to create a new account, please email support@bspsoftware.com

 

Using one request to make 3 lists aggregated on different columns

Started by delphdc2, 12 Apr 2010 09:29:15 AM

Previous topic - Next topic

delphdc2

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

MFGF

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.
Meep!