TypeFilterInclude (PEL)
This function generates a member set that includes all members with a dimension type that matches the specified type names.
Dimension_Expression.TypeFilterInclude(
Type_Names )
Parameters
- Dimension_Expression
A valid PEL (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 from Dimension_Expression that includes all members with a type that matches one of the specified Type_Names.
Remarks
This function can only be used as a part of 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 the use of TypeFilterInclude. This example generates a member set from the Flow dimension that includes all the members of the Flow type Closing.
SCOPE [Flow].TypeFilterInclude(
"Closing"
);