CanAllocate Property
The CanAllocate property returns whether you can allocate measure values to descendant levels and categories.
Syntax
object .CanAllocate
Applies To
Discussion
Use this property to determine whether you can allocate measures from one data source to levels and categories associated with another data source. Allocation distributes data, specified at a summary level of a dimension, to lower levels. You can allocate over
- an entire dimension when the measure appears in a data source that does not reference the dimension
- levels within a dimension when the measure is already specified at a level in that dimension
- categories within levels when the measure is specified to the particular level
For example, sales revenue may be tracked daily, but sales revenue is forecast quarterly. Allocation by proportion may be useful for distributing quarterly forecasts to the month and day levels.
This property is True only when the model uses at least two data sources.
A COM exception is thrown in error situations. The message that is passed with the exception varies depending on the error situation.
Type
Boolean
Access
Read
Examples
objLevel = objModel.Dimensions("Products").DimensionLevels(1)If objLevel.CanAllocate
= True Then