The Context of Your Business Data: Attributes » Using attributes to browse and report on data » Defining how attribute forms are displayed by default

Defining how attribute forms are displayed by default

You can generally display attribute forms in a number of ways. For example, the Distribution Center attribute in the MicroStrategy Tutorial consists of an ID form group and a Description form. The ID form group is made up of two separate ID columns, Country_ID and Dist_Ctr_ID.

Displayed on a report, the Dist_Ctr_ID form shows the identification numbers of specific distribution centers in the data warehouse. The Description form of Distribution Center, however, displays the actual name of the Distribution Center such as “San Diego.”

You can use the Attribute Editor to determine how the attribute forms are displayed on a report. In the case of the Distribution Center attribute, you can specify whether the identification number of each distribution center, the distribution center names, or both are displayed. You can also determine which attribute forms are displayed when browsing a project with the Data Explorer.

Follow the example procedure below to set one of the Distribution Center attribute’s forms to be displayed in reports and while browsing the MicroStrategy Tutorial project.

You can also use Architect to define how attribute forms are displayed in reports, as described in Creating and modifying multiple attributes.

To display an attribute form in reports and in the Data Explorer

1 In the MicroStrategy Tutorial, navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder.
2 Double-click the Distribution Center attribute. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Attribute Editor in edit mode so that you can make changes to the attribute. The Attribute Editor opens.
If you are only given the option of opening the Attribute Editor in read only mode, this means another user is modifying the project’s schema. You cannot open the Attribute Editor in edit mode until the other user is finished with their changes and the schema is unlocked.
For information on how you can use read only mode and edit mode for various schema editors, see Using read only or edit mode for schema editors.
3 Click the Display tab.

On the right, in the Report display forms pane, the description form of the Distribution Center is set as the only display form. This means that, when the Distribution Center attribute is used on a report, the actual names of the distribution centers are displayed. The ID 2 form in the Available forms pane represents the distribution centers’ identification numbers.

4 You can set the ID 2 form to be displayed in the following ways:
To set the ID 2 form as a form that is displayed on a report by default: Select ID 2 from the Available forms pane and click the top > button to add the form to the Report display forms pane on the right.
To set the ID 2 form so it is displayed in the Data Explorer when a user browses the Distribution Center attribute: Select ID 2 from the Available forms pane and click the bottom > button to add the form to the Browse forms pane on the right.

The Data Explorer makes hierarchies available for users to facilitate placing objects on reports. The Data Explorer is discussed in Hierarchy browsing.

5 You can also define the default sort order for attributes on reports and the Data Explorer. For information on attribute form sorting options, see Displaying forms: Attribute form properties.
6 Because this is only an example, close the Attribute Editor without saving your changes.

You can also determine how attributes are displayed while users are editing and viewing reports. See the Basic Reporting Guide for details.