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

currentMeasure

Started by CognosMarson, 23 Jul 2019 08:37:20 AM

Previous topic - Next topic

CognosMarson

Hi,

Is there a way to specify which measure to use with currentMeasure in a combination chart like in a crosstab?

here's an example: In the columns I have the mesasure for revenue and in the line I have a measure for 12 month moving average(a simple calculation using dynamic functions). When I use currentMeasure in the moving average measure it seems to use another measure than revenue, I can solve it by using "[revenue] within..." instead of currentMeasure, but I want a generic moving average which I can use in multiple visualizations instead of creating a new one all the time.

Another thing I've noticed is that sometimes when I try to drag the "moving average calculation" in to the line measure I get an error saying something like "It is only possible to insert a measure or a simple value into the selected location", this is the exact calculation that worked 10 minutes ago... Anyone have a solution or answer to that problem?

here's the calculation: average(currentMeasure/[Revenue] within set(lastPeriods(12;currentMember([Accounting].[Date].[Year]))))

Thanks CM