In this exercise you will learn to create Metrics. Take the following steps:
- Open the MicroStrategy Tutorial Project | navigate to My Exercises folder.
- Right click | New | Metric.
- By default the Object Browser will show the Facts folder. Double click on the Revenue Fact.
Notice that by default the aggregation is Sum; you can change this function by any other available. Browse to this location to check which other functions exist in MicroStrategy: Schema Objects | Functions and Operators. You can also click on the f(x) button on the metric expression window.
- Leave the other components with the default behavior (Dimensionality=Report Level, Condition=Nothing, Transformation=Nothing) | Save and Close | name ...