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

Cumulate measure

Started by ykud, 28 Nov 2006 01:39:37 AM

Previous topic - Next topic

ykud

I need to get something like @Cumul in Analyst in PowerPlay cube. There ought to be a nice&clean variant, just can't find it.  Running-Total calculation seems to be it, but it's inapplicable in Transformer. And preparing these values in data source (iqd or such) -- well, that's the backup variant. 

Initial data:
Month  Value
Jan         5
Feb        10
Mar        15
....
Required:
Month   Value   Cumul
Jan         5            5
Feb        10          15
Mar        15          30
....

Of course, there's more than 2 dims in this cube. And cumul should apply only to Months.
Month isn't a Time dimension, and if there is any variant without making it Time -- it'd be optimal.

Darek

I'm afraid you will have to provide the measure externally.

ykud

Yep, you're right. Thanks for answering.
Calculated running-total in database -- uploaded in powerplay.