Attribute qualification: Import rules

You can import filter elements into the Filter Editor from sources other than MicroStrategy. The following requirements must be met:

The filter is an attribute qualification.
The filter is qualified on an attribute form, not elements.
The operator must be In list or Not in list.
The elements to be imported are stored in an Excel file or a text file which meets the requirements described below.

The data in Excelspreadsheets must be stored in rows, columns, or both, as follows:

- For Excelfiles, data can be stored in rows, columns, or both:
If the data in a cell has double quotes in the first and last position, it is imported as it is, with the quotes.
If the data in a cell has single quotes in the first and last position, it is imported as it is, with the quotes.
If the data in a cell does not satisfy conditions 1 or 2, it is checked to see if it is a number. If the data is a number, it is imported as it is.
If the data in a cell does not does not satisfy conditions 1 or 2, it is checked to see if it is a date. If it is a date, it is imported by adding single quotes at the beginning and end to comply with the date format.
If the data in a cell does not satisfy any of the above conditions, it is considered text data and is imported by adding double quotes at the beginning and end to comply with the text format.

The data in text files must be one of the following: