Advanced Metric Creation Tool
I’m a big fan of Conditional Metrics, especially since the passes they generate get merged when using the SQL Global Optimization VLDB Setting. I find these types of metrics provide the most flexibility in design without compromising performance. One of the drawbacks though is that it can require a lot of redundant object creation that can become tedious. Fortunately, MicroStrategy provided a simple little tool in 9.0.1 for generating these metrics en masse. While it’s one of those tools you may only use once or twice, the times you do use it will save you tons of time.
Right click on the Metric and choose Create Advanced Metrics -> Add Filter
Note: This feature only works with basic metrics that are currently only Agg(Fact). It doesn’t support Compound Metrics or existing Conditional Metrics. It’s basically a shortcut for adding Filters and Transformations to existing basic Metrics.
The interface lets you add any combination of Metrics, Filters and Transformations. The checkboxes Include no filter/transformation controls whether or not to create versions of metrics that only have each individual filter/transformation, or if it should only create full combinations.