Show TOC

Syntax documentation*QUERY_FILTER Locate this document in the navigation structure

Allowed uses: By Commit, MDX

*QUERY_FILTER={member}

This instruction enforces a *QUERY_TYPE=2 (nonemptycrossjoin) in the MDX rules execution, and causes the system to search for existing values to be performed on the passed member.

Example Example

*QUERY_FILTER=NetProfit

End of the example.

The rules module assumes the member to be an account if no dimension is specified. Otherwise, the correct dimension can be explicitly named in the usual MDX format.

Example Example

*QUERY_FILTER=[CATEGORY].[ACTUAL]

End of the example.