Create Metrics in Bulk
//list all metrics in the project
String sProjectName = "Convenience Retail";
String sFactFolder = "\\Schema Objects\\Facts";
String sMetricFolder = "\\Public Objects\\Metrics";
ResultSet oFacts = executeCapture("LIST ALL FACTS IN FOLDER '" + sFactFolder + "' FOR PROJECT '" + sProjectName + "';");
oFacts.moveFirst();
while (!oFacts.isEof() )
{
//get name and path of this metric to list properties
String sFactName = oFacts.getFieldValueString(DisplayPropertyEnum.NAME);
//get properties of each metric
execute("CREATE METRIC \"" + sFactName + "\" IN FOLDER \"" + sMetricFolder + "\" EXPRESSION 'sum([" + sFactName + "])' ON PROJECT \"" + sProjectName + "\";");
oFacts.moveNext();
}