SYMPTOM:
A user creates a report based on an MDX cube in Strategy. Then the user adds two or more filters in the report filter based on metrics. The logical operator between the two filters cannot be changed. The operator between the filters is 'AND' and cannot be changed, as shown below:
CAUSE:
This is a limitation for MDX in Strategy. The way the MDX language works does not permit separate metric qualifications from being related through an OR statement.
ACTION:
Create a view filter instead of a report filter. In a view filter, the logical operator may be toggled, as shown below:
