Public objects
Public objects are also known as application objects, and are based on the schema objects. The following diagram shows all the public objects available in MicroStrategy:
![](https://static.packt-cdn.com/products/9781785884405/graphics/image_02_053.jpg)
In the following section, we will discuss these public objects in detail.
Metrics
Metrics are public objects that are built from attributes, facts, or other metrics that allow data aggregation. A metric definition contains a formula that determines the calculation to be performed on the data. At a high level, metrics can be categorized as:
Simple metrics
Advanced metrics
Types of metric
Simple metrics include:
Basic metrics: Simple aggregations of fact, for example SUM (amount), AVG (sale), and so on
Compound metrics: Combinations of two or more metric objects with one or more constant, mathematical operator, or non-aggregate function, for example, revenue = quantity * price, Runningavg (sales), where sales is a metric
Advanced metrics include:
Level metrics: Define the level at which the metric aggregates. By...