ClassificationFilterInclude (PEL)

This function generates a member set that includes specified account classifications in a SCOPE statement.

[Account].ClassificationFilterExclude(
   Classification_Names
   )

Parameters

  • Classification_Names
    Names of account classification types to be filtered. This expression can specify from 1 to 30 names, separated by commas. Classification_Names must be expressed as a string literal, such as "Income statement" or "Non financial".

Return Value

A member set that includes all members that use an account classification that matches one of the specified Classification_Names.

Remarks

This function can only be used in a Consolidation rule or Currency rule.

For more information about account classifications, see About the Account dimension.

The PEL compiler cannot generate SQL code for this function.

Example

The following example shows the use of ClassificationFilterInclude. This example generates a member set from the Account dimension that includes all accounts that use the classifications "Income statement" and "Non financial".

SCOPE 
        [Account].ClassificationFilterInclude(
           "Income statement",
           "Non financial")
END SCOPE;

See Also

Other Resources

PEL functions