MicroStrategy ONE
Filtering based on attribute form qualifications
You can qualify on attribute forms using the Where operator. Once you select an attribute form, you can use various logical and mathematical operators to create a view filter qualification based on an attribute form, to restrict data. An attribute form qualification using a Contains operator that restricts data to materials that contain Economy in their DESC form is shown below.
If you use this view filter with the TOP 5 Materials by Net Sales Amount and Quarter report, the resulting report is the same as the example scenario in Filtering data based on business attributes, which uses the attribute element qualification Material In list {UC.
You can use any of the following operators in attribute form qualifications. These operators are described in detail in the Logical and Mathematical Operators for Filtering appendix in the Advanced Reporting Help:
Operator Type |
Operator |
Comparison Operators Comparison operators compare values. The values can be numbers, text strings, or expressions. |
Exactly |
Different from |
|
Greater than |
|
Less than |
|
Greater than or equal to |
|
Less than or equal to |
|
Between |
|
Is Null |
|
Is Not Null |
|
Pattern Operators Pattern operators allow text strings to be compared. Pattern operators are case-sensitive. |
Like |
Not Like |
|
Contains |
|
Does not contain |
|
Begins with |
|
Does not begin with |
|
Ends with |
|
Does not end with |