MicroStrategy ONE

Modifying attribute display

Attribute forms are identifiers or descriptors of an attribute. You can view which attribute forms were selected for a particular report, as well as select different forms to be used in addition to or instead of the original forms. Attribute forms are displayed on the report as a part of an attribute on the report. They can also be in Report Objects without being displayed on the grid.

You can select the attribute forms to display by using either of the following methods:

  • To quickly move attribute forms between the grid/view and Report Objects, right-click an attribute and select a form in the Attribute Forms pop-up menu.

    Using this method, you can remove displayed forms from the grid/view, but not from Report Objects, and add them to Report Objects and the grid/view. You cannot set the attribute to use the default display. For instructions, see To move attribute forms between the grid and Report Objects below.

  • To add and remove attribute forms from the grid/view and Report Objects, and set the attribute to use the default display, from the Data menu, select Attribute Display. The Attribute Display dialog box opens.

    Using this method, you can add and remove attribute forms from both the grid/view and Report Objects. The default form is the attribute form that was chosen when the attribute was created. For instructions, see To add and remove attribute forms from the grid and Report Objects below.

Attribute Display is an OLAP services feature and you must have the "Use report objects" and "Set attribute display" privileges to use this feature. For more information on privileges, see Assign Access Privileges to a User.

To move attribute forms between the grid and Report Objects

  1. Open the report in the Report Editor or Report Viewer.

    You can also modify the attribute display on a template. Open the template in the Template Editor.

  2. Right-click the attribute, in either the Report Objects pane (for a report only) or on the grid, point to Attribute Forms, then choose the form to add or delete.

    In Grid view (the report is open in the Report Viewer), attribute forms in the top section of the right-click menu are already in Report Objects and therefore part of the report, although not displayed on it. Attribute forms in the second section of the right-click menu are not in Report Objects and therefore not part of the report. Adding an attribute form from the second section causes the report to be re-executed. A dialog box opens to confirm whether to re-execute the report.

If you selectMoreat the bottom of the right-click menu, the Attribute Display dialog box opens. The options on this dialog box are described in the following procedure.

To add and remove attribute forms from the grid and Report Objects

  1. Open the report in the Report Editor or Report Viewer.

    You can also modify the attribute display on a template. The only difference is that templates do not have Report Objects. Open the template in the Template Editor.

  2. From the Data menu, choose Attribute Display. The Attribute Display dialog box opens.

  3. From the Attribute drop-down list, select the desired attribute. The display options change to reflect the current settings.

  4. Select the Use the following attribute forms check box, if it is not already selected.

  5. To add forms to the report:

    • Select the attribute forms from the Available forms list.

    • Click > to add them to the list of Displayed forms.

      When a form is added to Displayed forms, it is also added to Report Objects forms.

  6. To remove forms from the view/grid, that is, the displayed report:

    • Select the attribute forms from the Displayed forms list.

    • Click < to remove them from the Displayed forms list.

  7. To rearrange the order of the displayed forms:

    • Select a form from the Displayed forms list.

    • Click the up or down arrow on the right side of the Displayed forms box.

  8. To add forms to Report Objects but not to the displayed report (for a report only):

    • Select the attribute forms from the Available forms list.

    • Click > to add them to the list of Report Objects forms.

  9. To remove forms from Report Objects (for a report only):

    • Select the attribute forms from the Report Objects forms list.

    • Click < to remove them from the Report Objects forms list.

    When a form is removed from Report Objects forms, it is also removed from Displayed forms.

    You cannot remove the ID form from Report Objects forms because this would remove the attribute from the report/template. As long as an attribute exists in Report Objects, the ID is also present because table joins are performed on the ID in SQL. Therefore, the ID is always available in the report results.

  10. To display the attribute's default form, select the Use the attribute's default display settings check box.

  11. Click OK. You are returned to the report, which displays the modified attribute forms.

    In Grid view, adding a form to or removing it from Report Objects causes the report to be re-executed. After you click OK, a dialog box opens to confirm whether to re-execute the report.

Related Topics