MicroStrategy ONE

Default Attribute Weight

The Default Attribute Weight is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

Use the Default Attribute Weight property to determine how attribute weights should be treated, for those attributes that are not in the attribute weights list.

You can access the attribute weights list from the Project Configuration Editor. In the Project Configuration Editor, expand Report Definition and select SQL generation. From the Attribute weights section, click Modify to open the attribute weights list.

The attribute weights list allows you to change the order of attributes used in the SELECT clause of a query. For example, suppose the Region attribute is placed higher on the attribute weights list than the Customer State attribute. When the SQL for a report containing both attributes is generated, Region is referenced in the SQL before Customer State. However, suppose another attribute, Quarter, also appears on the report template but is not included in the attribute weights list.

In this case, you can select either of the following options within the Default Attribute Weight property to determine whether Quarter is considered highest or lowest on the attribute weights list:

  • Lowest: When you select this option, those attributes not in the attribute weights list are treated as the lightest weight. Using the example above, with this setting selected, Quarter is considered to have a lighter attribute weight than the other two attributes. Therefore, it is referenced after Region and Customer State in the SELECT statement.
  • Highest (default): When you select this option, those attributes not in the attribute weights list are treated as the highest weight. Using the example above, with this setting selected, Quarter is considered to have a higher attribute weight than the other two attributes. Therefore, it is referenced before Region and Customer State in the SELECT statement.

Levels at Which You Can Set This

Database instance only