COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: CognosMarson on 08 May 2020 10:49:18 AM

Title: Calculating Rolling average
Post by: CognosMarson on 08 May 2020 10:49:18 AM
Hi,

can someone help me with calculating rolling average over a time period from a dimensional cube?

/CM
Title: Re: Calculating Rolling average
Post by: MFGF on 08 May 2020 11:07:39 AM
Quote from: CognosMarson on 08 May 2020 10:49:18 AM
Hi,

can someone help me with calculating rolling average over a time period from a dimensional cube?

/CM

Hi,

I can't try this at the moment, but the post below from Paul details how to set up a running total for OLAP package based reports. You might be able to adapt it for rolling averages?

https://www.cognoise.com/index.php/topic,6022.msg21806.html#msg21806

Cheers!

MF.