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.

See Also

Other Resources

PEL syntax elements