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