List Metric Properties statement

Lists the properties for an existing metric within a project.

LIST [ALL] PROPERTIES FOR METRICmetric_nameIN [FOLDER]location_pathFOR PROJECTproject_name;

where:

• metric_name is the name of the metric for which the properties will be listed, of type string, between double quotes (" ").

• location_path is the folder path where the metric is located, 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

LIST ALL PROPERTIES FOR METRIC "New Metric" IN FOLDER "\Public Objects\Metrics\Count Metrics" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

ALLOW_SMART_METRIC: Whether or not smart metrics are allowed, returned as a boolean value.

CONDITIONALITY: The condition associated with the metric, returned as a string.

CREATION_TIME: The date and time the metric was created, returned as a date/string.

DESCRIPTION: The description of the metric, returned as a string.

DIMENSIONALITY_RESULT_SET: A ResultSet containing information about the level of calculation for the metric.

• DIMENSIONALITY: The level of calculation from the metric, returned as a string.

EXPRESSION: The expression associated with the metric, returned as a string.

FORMULA: The metric formula, returned as a string.

HIDDEN: Whether or not the metric is hidden, returned as a boolean value.

ID: The object ID of the metric, returned as a string.

LONG_DESCRIPTION: The long description of the metric, returned as a string.

MODIFICATION_TIME:  The date and time the metric was last modified, returned as a date/string.

NAME: The name of the metric, returned as a string.

OWNER: The owner of the metric, returned as a string.

TRANSFORMATION_RESULT_SET: A ResultSet containing a list of the transformations associated with the metric.

• TRANSFORMATION: The name of the transformation, returned as a string.