Bulk Metric createion? 1

[bittmapp]

Hello,

is there a way to configure or create metrics outside the MSTR Desktop interface, like XML or something? Have to create hundreds of metrics.....

Thanks,

bitt

 

[spod]

YOu could use something like excel to build up the following expression for Command manager:

CREATE METRIC "New Metric" IN FOLDER "\Public Objects\Metrics\Count Metrics" EXPRESSION
"Count(Customer) {Country} <[Year 2001]>" ON PROJECT "MicroStrategy Tutorial";

Cols for the syntax which would repeat row by row, other cols for metric name, location and expressions (note here that it's sum(FACT_NAME).


e.g
col 1 - CREATE METRIC "
col 2 - list of all the metric names
col 3 - "IN FOLDER "
col 4 - locations of where you'd want the metric
col 5 - " EXPRESSION "
col 6 - sum/max/count etc.....
col 7 - (fact name)
col 8 - dimensionality
col 9 - conditionality
col10 - " ON PROJECT "Project name";

repeat cols 1, 3,5 & 10, fill in the other cols where applicable, copy and paste into command manager and roberts yer mothers brother.

 

[bittmapp]

Thanks so much, Spod.

Your ideas are great. Just what the Dr. ordered.

You get a star from me,

Thanks again,

bitt