Author Topic: Aggregation method in query studio  (Read 4318 times)

Offline ERL

  • Full Member
  • ***
  • Join Date: Dec 2012
  • Posts: 8
  • Forum Citizenship: +0/-0
Aggregation method in query studio
« on: 12 Sep 2014 01:16:27 pm »
Is it possible to change the aggregate method to none within query studio.  The data item comes in with an aggregation of total.

Offline nimda

  • Full Member
  • ***
  • Join Date: Sep 2014
  • Posts: 5
  • Forum Citizenship: +0/-1
Re: Aggregation method in query studio
« Reply #1 on: 12 Sep 2014 06:03:50 pm »
Hi!

I think it is possible.
In Query explorer you select data item and in properties windows you see option 'Aggregate function', change that value to whatever aggregation method you want.
Example screenshot of the window: http://4.bp.blogspot.com/-qFmZNlRXL60/T9I_ZP6s3bI/AAAAAAAAAB8/zji_riMy4zg/s1600/retn+-+properties+window.png

Hope this helped!

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,915
  • Forum Citizenship: +649/-10
  • Cognos Software Muppet
Re: Aggregation method in query studio
« Reply #2 on: 30 Sep 2014 04:03:18 am »
Hi!

I think it is possible.
In Query explorer you select data item and in properties windows you see option 'Aggregate function', change that value to whatever aggregation method you want.
Example screenshot of the window: http://4.bp.blogspot.com/-qFmZNlRXL60/T9I_ZP6s3bI/AAAAAAAAAB8/zji_riMy4zg/s1600/retn+-+properties+window.png

Hope this helped!

Hi,

The instructions and image you posted here are completely correct for Report Studio. They are not relevant to Query Studio though, sadly.

Is it possible to change the aggregate method to none within query studio.  The data item comes in with an aggregation of total.

If you are referring to the aggregation within footers, you can select the column, click on the "Edit Data" link in the blue area on the left, and select "Summarize". This allows you to choose how the value is aggregated in footers in the report.

If you are referring to how the measure values get automatically aggregated within the cells of the list column, then click on the "Run Report" link in the blue area, select "Advanced Options", and uncheck the option for "Automatically summarize detail values, suppressing duplicates".

Cheers!

MF.
Meep!

Offline bvk.cognoise

  • BVK
  • Statesman
  • ******
  • Join Date: Mar 2011
  • Posts: 292
  • Forum Citizenship: +11/-2
  • Think-Do-Be<Positive>
Re: Aggregation method in query studio
« Reply #3 on: 01 Oct 2014 07:27:49 am »
HI ERL,

Please follow below mentioned steps so that you can remove aggregations automatically

>From the Manage File menu, click My Preferences.
>Click Advanced Run-time Options.
>In the Query Options dialog box, choose an option:
To turn off the automatic generation of footer summaries for measures, clear the Automatically generate footer summaries for measures check box.

Regards
bvk
Regards
BVK

 


       
Twittear