Author Topic: Median calculation in Query Studio  (Read 3048 times)

Offline cbelobr

  • Associate
  • **
  • Join Date: Jun 2013
  • Posts: 3
  • Forum Citizenship: +0/-0
Median calculation in Query Studio
« on: 12 Jun 2013 12:56:18 pm »
I am new to Cognos.  Currently on Cognos 10.

My question: Is there a 'Median' calculation in Query Studio? If so, how can I find it?

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,701
  • Forum Citizenship: +341/-1
Re: Median calculation in Query Studio
« Reply #1 on: 12 Jun 2013 03:03:35 pm »
I don't think you'll find that in Query Studio. If you are on Cognos 10 then why not consider moving to Cognos Workspace Advanced (or Business Insight Advanced if you are on 10.1)?

It is a single business user authoring environment for both dimensional and relational sources and is quite a bit more robust than Query Studio or Analysis Studio.

Offline RKMI

  • Community Leader
  • *****
  • Join Date: Sep 2012
  • Posts: 248
  • Forum Citizenship: +19/-0
Re: Median calculation in Query Studio
« Reply #2 on: 13 Jun 2013 06:03:52 pm »
Hi,

You find a median at a summarize level just right click on your fact cell ( unit of measure) > click summarize then you will see in the drop down Median.

Thanks,
RK
"Inflexibility comes from lack of imagination" ~ RK

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,701
  • Forum Citizenship: +341/-1
Re: Median calculation in Query Studio
« Reply #3 on: 14 Jun 2013 07:46:12 am »
Hi,

You find a median at a summarize level just right click on your fact cell ( unit of measure) > click summarize then you will see in the drop down Median.

Thanks,
RK

Ah, summary level! Never thought to look there. I was thinking only of the calculations available within and did not see it there. Very good RKMI!

Offline RKMI

  • Community Leader
  • *****
  • Join Date: Sep 2012
  • Posts: 248
  • Forum Citizenship: +19/-0
Re: Median calculation in Query Studio
« Reply #4 on: 14 Jun 2013 10:28:58 am »
Thanks Lynn. :) By way good luck on your IOD Session.
"Inflexibility comes from lack of imagination" ~ RK

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,701
  • Forum Citizenship: +341/-1
Re: Median calculation in Query Studio
« Reply #5 on: 14 Jun 2013 10:54:46 am »
Thanks Lynn. :) By way good luck on your IOD Session.

Thanks for the good luck wish....good thing it has nothing to do with summary calcs in Query Studio :)

 


       
Twittear