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

Question on detail aggregation

Started by asmfloyd, 03 Jan 2023 04:04:16 PM

Previous topic - Next topic

asmfloyd

Hi,
  I have a beginner question.
I am union'ing 2 queries in report studio. Each of the query is rolling up data based on detail aggregation property as 'Total' (As an example for a row, the measure column "Meas" adds three rows' values  10+5+15 from 3 rows and give as 30).
Now After the union, unless I make the detail aggregation in the union'ed query also as "Total", it splits the row again into three separate rows with Meas values as 10,5 and 15. Is there any option to avoid this behavior OR It always need this change?

Thanks,

BigChris

That's what I'd expect it to do - the union query has it's own aggregation rules so you'd need to specify total there. The child / sub queries won't effect the aggregation in the union