TypeFilterExclude (PEL)
This function generates a member set that contains all members from the specified dimension except those of the specified types.
Dimension_Expression.TypeFilterExclude(
Type_Names )
Parameters
- Dimension_Expression
A valid PerformancePoint Expression Language (PEL) dimension. This value must be one of [Account] or [Flow].
- Type_Names
Names of account or flow types to be filtered. This expression can specify from 1 to 30 names, separated by commas. Type_Names must be expressed as a string literal, such as "PY Adj" or "Opening".
Return Value
A member set that contains all the members from Dimension_Expression except those with a type that matches one of the specified Type_Names.
Remarks
This function can only be used in a Consolidation rule or Currency rule.
For more information about account types, see About the Account dimension.
For more information about Flow types, see About the Flow dimension.
The PEL compiler cannot generate SQL code for this function.
Example
The following example shows a scope statement that uses the TypeFilterExclude function. The function generates a member set from the Flow dimension that excludes the following members, which are Flow types.
"PY Adj"
"Opening"
"Appropriation"
"Closing"
SCOPE [Flow].TypeFilterExclude(
"PY Adj",
"Opening",
"Appropriation",
"Closing"
);