MicroStrategy ONE
Configuring whether to use aliases in the filter details
Before you begin
This topic assumes that you are familiar with filters, especially the different types of filters and the components of filters. For background information, see Filters.
The filter details display the report filter and report limit of the report by default, although other types of filters can be displayed. For more information on displaying other types, see Configuring the content of the filter details.
You can rename an object on a report, to display a more meaningful description in the context of that particular report, for example. An alias does not change the name of the object, only the name displayed on the report. A filter still uses the name of the object, not the alias. You can determine whether aliases replace object names in the filter details.
For example, the Revenue metric has been aliased as Sales. The first example below uses the alias, while the second does not.
(Region = Northeast, Mid-Atlantic, Southeast) AND (Sales > 6,000,000)
(Region = Northeast, Mid-Atlantic, Southeast) AND (Revenue> 6,000,000)
By default, each of these settings inherits the project-level report detail definitions set in the Project Configuration Editor, as described in Levels of report details configuration. You can return to this default by selecting <default> from the drop-down list.
Interaction of report details preferences and filter details
The report details preferences specified in the Developer Preferences dialog box specify which types of report details are displayed. These preferences override some of the report details that are configured in the Report Details Properties dialog box in the Project Configuration Editor and in the Report Editor. The report details preferences specify whether the filter details are displayed.
-
If the report details preferences specify that the filter details are not displayed, you cannot display them using the Report Details Properties dialog box.
-
If the report details preferences specify that the filter details are displayed, you cannot hide them using the Report Details Properties dialog box. You can use the Report Details Properties dialog box to configure how they are displayed, however.
You can change this behavior by disabling the report details preferences, allowing the report details properties to be used instead. You can disable the report details preferences when you save changes to the report details properties (as described in Configuring the content of the filter details) or by using the Developer Preferences dialog box (for instructions, see Disabling report details preferences). For more information about the report details preferences in general, and how to set them, see Enabling and customizing report details preferences.