MicroStrategy ONE

List Metrics statement

Lists all the metrics for a given project.

Copy 
LIST [ALL] METRICS [IN [FOLDER] location_path] [FOR OWNER login_name] FOR PROJECT project_name;

where:

  • location_path is the folder path for which all the metrics will be listed, of type string, between double quotes (" ").

  • login_name is the login of the user who is the owner of the listed metrics, of type string, between double quotes (" ").

  • project_name is the name of the project for which all the metrics will be listed, of type string, between double quotes (" ").

This statement can only be executed in a Windows environment.

Examples

Copy 
LIST 
 ALL METRICS FOR PROJECT "MicroStrategy Tutorial";
Copy 
LIST ALL METRICS IN FOLDER "\Public Objects\Metrics\Count 
 Metrics" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

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

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

PATH: The path to the metric, returned as a string.