MicroStrategy ONE

How to Create Multi-Form Attributes

When you import data, each column in a table imports as a separate attribute. If your data contains different attribute forms of the same attribute saved in separate columns, you can create a multi-form attribute to combine the forms into a single attribute.

The LU_CALL_CENTER TABLE contains two columns, Call Ctr ID and Call Center Name, which will be imported as two attributes. You can create a single Call Center attribute that uses the columns as attribute forms.

You have already begun importing data. The Preview dialog appears after you select a data source to import from, select the data to import, and click Prepare Data. See Import Data for a list of data sources you can import from, as well as links to steps for importing data.

You cannot create multi-form attributes on data imported from a search.

To Create a Multi-Form Attribute During Data Import

  1. In the top pane of the Preview dialog, click the columns you want to use as attribute forms to select them. Press and hold the Ctrl key to select multiple columns.
  2. Right-click the selected columns and select Create Multi-form Attribute.
  3. Enter a name to use for the new attribute in New Attribute Name.
  4. Select the correct Form Category, such as ID or Description, from the drop-down.
  5. Select the Display Form checkbox to display the attribute form.
  6. Click Submit.

Related Topics

Preview Data and Specify Import Options

Introduction to Attributes