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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Auto Group & Summarize problem

Started by pucovsky, 15 Mar 2011 07:15:21 AM

Previous topic - Next topic

pucovsky

Hi

I have a package containing Query Subject Definition with Generate SQL set as As View in Framework Manager.
In Report Studio I have 2 data items used from this package's Query Subject in my query:

ID - with Aggregate Function property set to None
QTY - with Aggregate Function property set to Total

Query property Auto Group & Summarize is set to Yes.

As a result I want a report of IDs grouped and QTYs related to IDs totaled.
I have 10 distinct IDs and 10 rows should be the correct result.
Unfortunately I get all 1000 detail rows, IDs aren't grouped.
What am I doing wrong here?

Can you help with this? Thx.

Arsenal

I am not 100% sure of what is happening on your end, but the auto group and summarize will likely kick in only when dealing with rows that have the exact same attributes and in this case, the measures will be summed for these rows
As soon as a row is encountered with even one attribute different than the others but with the same ID, that row will be displayed. IN other words:

ID            Attrib1 Attrib2 Attrib 3  Measure 1

123         A           A        A             100
123         A           A        A              50

Will show as one single row with 150 for the measure. If any of the attribs are not A, then that row will be displayed and not rolled up

You could try playing around with the aggregate function and set it to Automatic and see if that helps. You could also try gouping on the report. Alternatively, you can exclude the attribute that makes the row different from the others (in other words, only include higher level rows) if that is ok with your reporting needs.