MicroStrategy Functions Reference
© 2011 MicroStrategy, Inc.
fact 1) A measurement value, often numeric and typically
aggregatable, stored in a data warehouse.
2) A schema object representing a column in a data
warehouse table and containing basic or aggregated
numbers—usually prices, or sales in dollars, or inventory
quantities in counts.
See also metric.
hierarchy A set of attributes defining a meaningful path for element
browsing or drilling. The order of the attributes is
typically—though not always—defined such that a higher
attribute has a one-to-many relationship with its child
metric 1) A business calculation defined by an expression built with
functions, facts, attributes, or other metrics. For example:
Sum(dollar_sales) or [Sales] - [Cost].
2) The MicroStrategy object that contains the metric
definition. It represents a business measure or key
See also fact.
schema object MicroStrategy object created, usually by a project designer,
that relates the information in the logical data model and
physical warehouse schema to the MicroStrategy
environment. These objects are developed in MicroStrategy
Architect, which can be accessed from MicroStrategy
Desktop. Schema objects directly reflect the warehouse
structure and include (among others) attributes, facts,
functions, hierarchies, operators, partition mappings, tables,