Types (PEL)
A PerformancePoint Expression Language (PEL) data type consists of a basic type and a set of data type attributes.
For more information about type attributes, see Data type attributes
PEL defines certain conversions between its fundamental types. These conversions are called standard conversions or implicit conversions. For more detail about standard conversions, see Type conversions (PEL).
Basic Types
The following table shows the PEL basic types.
Type
Description/example
ArgumentCount
A Count (PEL) function parameter that specifies how to count empty elements. This parameter must be on of EXCLUDEEMPTY or INCLUDEEMPTY
ArgumentDescendants
A Descendants (PEL) function parameter that distinguishes the kinds of descendants. The following table shows the possible values for this parameter.
Value
Description
AFTERReturns descendant members from all levels that are subordinate to the specified level or distance
BEFOREReturns descendant members from all levels that are superior to the specified level or distance
BEFORE_AND_AFTERReturns descendant members from all levels that are superior to or subordinate to the specified level or distance.
LEAVESReturns leaf descendant members at the specified level or distance, or those that are superior to the specified level or distance.
SELFReturns descendant members from the specified level or distance
SELF_AND_AFTERReturns descendant members from the specified level or distance, or those that are subordinate to the specified level or distance
SELF_AND_BEFOREReturns descendant members from the specified level or distance, or those that are superior to the specified level or distance
SELF_BEFORE_AFTERReturns all descendant members
Boolean
TRUE, FALSE
ConsolidationICMethod
An ICMethod (PEL) parameter: ICMethod(#Full#), ICMethod(#Holding#)
ConsolidationMethodSpec
A specification for applying consolidation calculations.
Equity, Full, Holding, Proportional
ConsolidationMethod
A Method (PEL) parameter: Method(#Full), Method(#Equity)
ConsolidationUsePartnerEntity
USEPARTNERENTITY
Dimension
An organized hierarchy of categories that describe data.
[Scenario], [Account]
Hierarchy
A tree structure that organizes a dimension.
[Time].[Calendar]
Level
A member of a hierarchy.
[Time].[Calendar].[Monthly]
MemberSet
A collection of members from a dimension.
{[Time].[Calendar].[Monthly].[January 2007], [Time].[Calendar].[Monthly].[February 2007]}
Member
Child of type MemberSet; a single position in a dimension.
[Time].[Calendar].[Monthly].[January 2007]
Model
A basic unit of storage that organizes dimensions and business rules, and that defines business logic and calculations.
MODEL([Exchange Rates])
Null
NULL
Number
1, 1.0, NULL
Integer
Child of type Number.
Whole number n, signed, where n is in the range –2[31] <= n <= 2[31] – 1.
Real
Child of type Number.
Decimal number in range zero or absolute value 10[–28] to 10[28]. May be expressed in E notation, such as 1.7E+3.
Scope
([Time].[Calendar].[Monthly].[Year 2007].LeafMembers,
{[Geography].[Geography].[Asia],
[Geography].[Geography].[Europe]}
)
String
Collection of alphanumeric characters, enclosed in quotation marks.
"abc", "International Accounts"
TupleSet
An ordered set of attributes that form an attribute hierarchy.
([Time].[Calendar].[Monthly].[Year 2007],
[Geography].[Geography].[Asia])
Tuple
Child of type TupleSet.
Scope
{ ([Time].[Calendar].[Monthly].[Year 2007]) }
A given basic type is an instance of any one of its parent types. For example, an object of basic type Integer is also of the Number basic type.