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:

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 default...