mondrian3.2之Writing a schema

Writing a schema ！终于看完了！笔记做了32页，辛苦了！！！！

Element

Description

<Schema>

Collection of Cubes, Virtual cubes, Shared dimensions, and Roles.

Logical elements

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

Dimension.

<DimensionUsage>

Usage of a shared dimension by a cube.

<Hierarchy>

Hierarchy.

<Level>

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

Member property. The definition is against 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>

Measure.

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

Physical elements

<Table>

Fact or dimension table.

<View>

Defines a 'table' using a 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.

Aggregate Tables

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

Access control

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

Extensions

<UserDefinedFunction>

Imports a user-defined function.

Miscellaneous

<Annotations>

Holder for annotations.

<Annotation>

User-defined property attached to a metadata element.

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