COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Metric Modeling (Metric Designer) => Topic started by: frog on 07 May 2009 03:16:35 AM

Title: automatically calculated metric
Post by: frog on 07 May 2009 03:16:35 AM
Hello...I create some metrics in a Metric Studio project. Values will be loaded by users or using tab-delimited files.I would need then to create a metric which is the 'running sum' over the months of one of the metric already defined and loaded. For example metric1 has values 10 for January, 10 for February. My new metric, that has to be automatically calculated, should have values 10 for January, 20 for February and so on...Any hint???
Thanks a lot!
Title: Re: automatically calculated metric
Post by: francois on 23 Jul 2009 05:26:12 AM
Not sure but i suppose you can create a new metric type with the expression is the sum of your different metrics the users enter values in and then select a sum of individual values as the rollup calculation for the actual of this new metric type.

is this your question ?