Alter Metric statement

Modifies the properties of an existing metric within a project.

ALTER METRIC metric_name IN [FOLDER] location_path [NAME new_metric_name] [EXPRESSION new_expression] [DESCRIPTION new_description] [LONGDESCRIPTIONlong_description] [LOCATION new_location_path] [HIDDEN (TRUE | FALSE)] [ALLOWSMARTMETRIC (TRUE | FALSE | LEAVEASIS)] [REMOVEREPORTFILTERELEMENTS (TRUE | FALSE)] [TOTALSUBTOTALFUNCTION (AVERAGE | COUNT | DEFAULT| GEOMETRICMEAN | MAXIMUM | MEDIAN | MINIMUM | MODE | NONE | PRODUCT | STANDARDDEVIATION | SUM | VARIANCE)] [DYNAMICAGGREGATIONFUNCTION (AVERAGE | COUNT | DEFAULT| GEOMETRICMEAN | MAXIMUM | MEDIAN | MINIMUM | MODE | NONE | PRODUCT | STANDARDDEVIATION | SUM | VARIANCE)] [COLUMNALIAS column_alias] ON PROJECT project_name;

where:

• metric_name is the name of the metric to be modified, of type string, between double quotes (" ").

• location_path is the folder path where the metric is located, of type string, between double quotes (" ").

• new_metric_name is the new name of the metric, of type string, between double quotes (" ").

• new_expression is the new metric expression, of type string, between double quotes (" "). For the syntax of metric expressions in Command Manager, see Metric expressions syntax.

• new_description is the new description of the metric, of type string, between double quotes (" ").

• long_description is the new long description of the metric, of type string, between double quotes (").

• new_location_path is the new folder path where the metric will be moved, of type string, between double quotes (" ").

• column_alias is the new column alias for the metric, of type string, between double quotes (").

• project_name is the name of the project that contains the metric, of type string, between double quotes (" ").

This statement can only be executed in a Windows environment.

Example

ALTER METRIC "New Metric" IN FOLDER "\Public Objects\Metrics\Count Metrics" LOCATION "\Public Objects\Metrics" FOR PROJECT "MicroStrategy Tutorial";