Mondrian Schema Element Reference
All of the possible Mondrian schema elements are defined in brief below, listed in the hierarchy in which they are used. To see a more detailed definition and a list of possible attributes and content, click on an element name.
| Element | Definition |
| <Schema> | A complete Mondrian schema; a collection of cubes, virtual cubes, shared dimensions, and roles. |
| <Cube> | A collection of dimensions and measures, all centered on a fact table. |
| <VirtualCube> | A cube defined by combining the dimensions and measures of one or more cubes. A measure originating from another cube can be a <CalculatedMember>. |
| <CubeUsages> | Base cubes that are imported into a virtual cube. |
| <CubeUsage> | Usage of a base cube by a virtual cube. |
| <VirtualCubeDimension> | Usage of a dimension by a virtual cube. |
| <VirtualCubeMeasure> | Usage of a measure by a virtual cube. |
| <Dimension> | Defines a dimension: a collection of hierarchies. |
| <DimensionGrant> | Grants or denies this role access to a dimension. |
| <DimensionUsage> | Usage of a shared dimension by a cube. |
| <Hierarchy> | Specifies a predefined drill-down. |
| <Level> | A level of a hierarchy. |
| <KeyExpression> | SQL expression used as key of the level, in lieu of a column. |
| <NameExpression> | SQL expression used to compute the name of a member, in lieu of Level.nameColumn. |
| <CaptionExpression> | SQL expression used to compute the caption of a member, in lieu of Level.captionColumn. |
| <OrdinalExpression> | SQL expression used to sort members of a level, in lieu of Level.ordinalColumn. |
| <ParentExpression> | SQL expression used to compute a measure, in lieu of Level.parentColumn. |
| <Property> | A member property. The definition is contained in a hierarchy or level, but the property will be available to all members. |
| <PropertyExpression> | SQL expression used to compute the value of a property, in lieu of Property.column. |
| <Measure> | Specifies an aggregated numeric value. |
| <CalculatedMember> | A member whose value is derived using a formula, defined as part of a cube. |
| <NamedSet> | A set whose value is derived using a formula, defined as part of a cube. |
| <Table> | A fact or dimension table. |
| <View> | Defines a table by using an SQL query, which can have different variants for different underlying databases. |
| <Join> | Defines a table by joining a set of queries. |
| <InlineTable> | Defines a table using an inline dataset. |
| <Closure> | Maps a parent-child hierarchy onto a closure table. |
| <AggExclude> | Exclude a candidate aggregate table by name or pattern matching. |
| <AggName> | Declares an aggregate table to be matched by name. |
| <AggPattern> | Declares a set of aggregate tables by regular expression pattern. |
| <AggFactCount> | Specifies name of the column in the candidate aggregate table which contains the number of fact table rows. |
| <AggIgnoreColumn> | Tells Mondrian to ignore a column in an aggregate table. |
| <AggForeignKey> | Maps a foreign key in the fact table to a foreign key column in the candidate aggregate table. |
| <AggMeasure> | Maps a measure to a column in the candidate aggregate table. |
| <AggLevel> | Maps a level to a column in the candidate aggregate table. |
| <AggTable> | A definition of an aggregate table for a base fact table. |
| <Role> | An access-control profile. |
| <SchemaGrant> | A set of rights to a schema. |
| <CubeGrant> | A set of rights to a cube. |
| <HierarchyGrant> | A set of rights to both a hierarchy and levels within that hierarchy. |
| <MemberGrant> | A set of rights to a member and its children. |
| <Union> | Definition of a set of rights as the union of a set of roles. |
| <RoleUsage> | A reference to a role. |
| <UserDefinedFunction> | Imports a user-defined function. |
| <Parameter> | Part of the definition of a hierarchy; passed to a MemberReader, if present. |
| <CalculatedMemberProperty> | Property of a calculated member. |
| <Formula> | Holds the formula text within a<NamedSet> or <CalculatedMember> . |
| <ColumnDefs> | Holder for <ColumnDef> elements. |
| <ColumnDef> | Definition of a column in an <InlineTable> dataset. |
| <Rows> | Holder for <Row> elements. |
| <Row> | Row in an <InlineTable> dataset. |
| <Value> | Value of a column in an <InlineTable> dataset. |
| <MeasureExpression> | SQL expression used to compute a measure, in lieu of Measure.column. |
| <SQL> | The SQL expression for a particular database dialect. |