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

Calculating Rolling average

Started by CognosMarson, 08 May 2020 10:49:18 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

CognosMarson

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

MFGF

#1
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.
Meep!
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite