MicroStrategy ONE

Create and Edit Attributes

Attributes are MicroStrategy schema objects that represent information about your business. They provide additional context to your reporting, allowing your users to understand the values of facts and metrics across various parameters.

In MicroStrategy Workstation, architects can create and edit attribute objects. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms.

Create an Attribute

  1. Open the Workstation window with the Navigation pane in smart mode.
  2. Ensure that the project schema for your new attribute is available for editing. You can unlock the schema in the Schema Editor by clicking the lock icon for the project.
  3. Choose File > New Attribute.
  4. In Name, enter a descriptive name for the attribute.
  5. Click Add New Form.
  6. Enter a name for the form. By default, the first form is the key form. Once additional forms have been created, you can assign a different key form.
  7. A new attribute expression is created. You can click Add New Expression to define multiple expressions for a single attribute form.
  8. Use the Tables pane to search for and multi-select the logical tables you want to associate with this attribute form expression. The Available Columns pane displays which columns are common across the logical tables you select.
  9. Use the Expression pane to define the expression for the columns you would like to use.
  10. Click Done.
  11. Use the Additional Properties tab to change parameters such as Description, Multiple Languages, Geographical. Role, Image Layout Shape File, and Alias.

Create a Compound Attribute

  1. Select multiple attribute forms, right-click, and choose Group.
  2. Right-click the group and choose Set as key.

Define Attribute Relationships

  1. Select the Relationships tab.
  2. To add a parent attributes, drag the appropriate attributes from the Candidates list into the Parent drop zone under Directly Related Attributes.
  3. Change the attribute's relationship with the base attribute in the drop-down.
  4. Repeat the same steps in the Children drop zone to define child attributes.

Define Attribute Forms for Report Display and Browsing

  1. Select the Display & Sort tab.
  2. To add attribute forms for report display, drag them from the Candidates list to the Report Display tab under Display Forms.
  3. To add attribute forms for sorting in reports, drag them from the Candidates list to the Report Display tab under Sort Criteria.
  4. If you want to add different attribute forms for display and sorting when users browse your objects, use the corresponding checkboxes on the right. Then drag the attributes to the appropriate Browse tab.
  5. Click Save.

Edit Attributes

  1. Open the Workstation window with the Navigation pane in smart mode.
  2. In the Navigation pane, click Projects and browse to the location of the attribute you want to edit.
  3. Right-click the attribute and choose Edit.
  4. Use the edit icons in the top pane to modify each item in the attribute form.

  5. To edit expression or property information, right-click the attribute form and choose Edit Expression or Edit Other Information.
  6. To change the lookup table for all expressions at once, click Lookup Table and choose Set Lookup Table Per Form.

  7. To change the form key, right-click the form and choose Set as key.
  8. To delete an attribute form, right-click it and choose Delete.