RunningPeriods Property

The RunningPeriods property sets or returns the number of time periods used for calculating running totals.

Syntax

SpecialCategory .RunningPeriods

Applies To

Discussion

Use this property with the TargetLevel, ContextLevel, TargetOffset, and ContextOffset properties to define a special category that tracks measures for specific periods of time relative to the current time.

To use this property, the Aggregate property must be set to either trAggregateRunning or trAggregateRunningGrouped. For example, create a running total category that spans the six months leading up to the current month, for this year and last year.

Aggregate = trAggregateRunningGrouped

ContextLevel = "Year"

ContextOffset = -1

TargetLevel = "Month"

TargetOffset = 0

RunningPeriods = 6

Type

Long

Access

Read/Write

Examples

objSpecCategory 
= _    objModel.Dimensions("Time").Categories
	.Add(xtrObjectType.trSpecialCategory)objSpecCategory.RunningPeriods
= 5