Author Topic: % summarized in Active Reports  (Read 441 times)

Offline b737

  • Senior Member
  • ****
  • Join Date: Jun 2013
  • Posts: 67
  • Forum Citizenship: +0/-0
% summarized in Active Reports
« on: 29 Dec 2017 08:11:20 am »
Hi,

I have problem with summarized % in active reports.

I am using Year and Month in Data Discrete Sliders, where Month slider is set to Range because I want to allow user to choose period of month. I have created %dataItem =[currentYear]/[beforeYear]*100-100 where [currentYear] is DataItem = currentMember([Model].[Year].[Year]) and [beforeYear] is DataItem=nextMember([currentYear]), where  [currentYear]  I choose from Year data slider.

Problem is that when it choose range of months, for example 1 to 7 Cognos active report summarize % for every month, and does not calculate for period from january-july (1-7). I had similar problem in Report studio, but I solve it using calculated aggregation and Solve order= 2  putting to % dataItem, but here does not do it.

Please see attachment

Tnx for help

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,100
  • Forum Citizenship: +612/-10
  • Cognos Software Muppet
Re: % summarized in Active Reports
« Reply #1 on: 29 Dec 2017 08:25:12 am »
Hi,

I have problem with summarized % in active reports.

I am using Year and Month in Data Discrete Sliders, where Month slider is set to Range because I want to allow user to choose period of month. I have created %dataItem =[currentYear]/[beforeYear]*100-100 where [currentYear] is DataItem = currentMember([Model].[Year].[Year]) and [beforeYear] is DataItem=nextMember([currentYear]), where  [currentYear]  I choose from Year data slider.

Problem is that when it choose range of months, for example 1 to 7 Cognos active report summarize % for every month, and does not calculate for period from january-july (1-7). I had similar problem in Report studio, but I solve it using calculated aggregation and Solve order= 2  putting to % dataItem, but here does not do it.

Please see attachment

Tnx for help

Hi,

If I'm understanding correctly, what you want to do in terms of recalculating "live" within your rendered active report output is not possible. The calculations are performed when the MHT output is rendered, and the results are included in the rendered output. Moving the slider is simply moving you to a different pre-rendered result. If you choose multiple values, you see multiple results.

Cheers!

MF.
Meep!

Offline b737

  • Senior Member
  • ****
  • Join Date: Jun 2013
  • Posts: 67
  • Forum Citizenship: +0/-0
Re: % summarized in Active Reports
« Reply #2 on: 29 Dec 2017 08:44:25 am »
I understand that everything is calculated before, but I am interested to know is there any chance to ''tell'' active report to calculate % difference of years  after it summarize period of months.

If that is not possible do you maybe have idea how to create this kind of active report with this periods of months, maybe with some DMR function or something else.

Thnx for fast replay and help 

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,100
  • Forum Citizenship: +612/-10
  • Cognos Software Muppet
Re: % summarized in Active Reports
« Reply #3 on: 29 Dec 2017 10:04:18 am »
I understand that everything is calculated before, but I am interested to know is there any chance to ''tell'' active report to calculate % difference of years  after it summarize period of months.

If that is not possible do you maybe have idea how to create this kind of active report with this periods of months, maybe with some DMR function or something else.

Thnx for fast replay and help

Hi,

The only options you have for recalculating things within the rendered output are the summaries from the toolbar. The "Summarize in output" section of summaries will recalculate based on any filtering you do with active report variables for your list/crosstab etc. They are not available in calculations, though, and there is no % summary in that section anyway.

If you are using controls in your active report output to filter or select content, there is no way to have calculations in the report automatically respond in the way you are hoping for here, sadly. Dimensional functions are relevant to accessing members and measures in a cube, but in an Active Report you're one step past that - the output has already been rendered with the data baked into it, and you are interacting within that saved output. This means you can't use dimensional functions.

In short, I don't think what you're looking for here is possible in an Active Report. :(

Cheers!

MF.
Meep!

 


       
Twittear