MicroStrategy ONE
Advanced Metric Assistant: Metric, Filter, and Transformation tabs
This Advanced Metric Assistant allows you to combine simple metrics with filters or transformations to create metrics with additional analysis capabilities.
To select metrics, filters, and transformations to combine, you can use the Metric, Filter, and Transformation tabs, respectively. Each tab allows you to browse through the project folders for the associated object type. You can use the arrows to add or remove a metric, filter, or transformation.
You can also choose whether to add filters, transformations, or both. This can be done by displaying or hiding the Filter and Transformation tabs, as described below:
-
If the Filter tab is not shown, from the Options menu, select Show Filters. You can also choose to hide this tab if you do not plan to combine metrics with filters. To hide the Filter tab, from the Options menu, select Hide Filters.
-
If the Transformation tab is not shown, from the Options menu, select Show Transformations. You can also choose to hide this tab if you do not plan to combine metrics with transformations. To hide the Transformation tab, from the Options menu, select Hide Transformations.
If you include both filters and transformations to combine with metrics, you can specify the types of metric combinations created, as described below:
-
Metrics are always created to combine each metric with all filter and transformation combinations. These metrics include both a filter and a transformation.
-
To create metrics that combine metrics with transformations only, select the Include no filter check box. These metrics do not include the selected filters.
-
To create metrics that combine metrics with filters only, select the Include no transformation check box. These metrics do not include the selected transformations.
You can click Next to open the Run page and review the metrics that are created by selecting or clearing the check boxes described above. You can then click Back to make any required changes.
Once you have made all the required metric and filter or transformation selections, click Next to begin creating metrics by combining the selected objects together. The Run page opens.