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.
I'm afraid you will have to provide the measure externally.
Yep, you're right. Thanks for answering.
Calculated running-total in database -- uploaded in powerplay.