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

% summarized in Active Reports

Started by b737, 29 Dec 2017 08:11:20 AM

Previous topic - Next topic

b737

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

MFGF

Quote from: b737 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

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!

b737

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 

MFGF

Quote from: b737 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

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!