FILTER

Description

Filter the Node with the given filter values. The result will only contain the rows of the input cube that fulfill the filter.

Signature

FILTER(Node, Level , FilterValue <, FilterOperation>)

Parameters

• Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
• Level: The level by which the input node shall be filtered
• FilterValue: The value by which the input node shall be filtered. This can either be a single string value or a list of strings
• FilterOperation: How are the values checked against the filter. The default is "EQ"(equality). Other possible values are: "NEQ"(Not equals), "GT"(greater than), "GTE"(greater than or equals), "LT"(less than) and "LTE"(less than or equals).