# Schema Workbench

#### Documents

{% file src="<https://content.gitbook.com/content/VLCJbSi5xQoetAvNtGiu/blobs/lwK51YDTjopFrCBP7oWf/Mondrian-3.0-Technical-Guide.pdf>" %}

{% file src="<https://content.gitbook.com/content/VLCJbSi5xQoetAvNtGiu/blobs/Ptizohqvg75xumNguwVo/Introduction%20to%20Mondrian%20Performance%20Tuning.pdf>" %}

{% file src="<https://content.gitbook.com/content/VLCJbSi5xQoetAvNtGiu/blobs/22HqRYgUREux5oDuDQ4B/Mondrian_in_Action.pdf>" %}

{% file src="<https://content.gitbook.com/content/VLCJbSi5xQoetAvNtGiu/blobs/4QiwqNeN9giZRgrSROL8/MDX%20Queries.docx>" %}

***

#### Online References

{% embed url="<https://docs.pentaho.com/pdia-metadata-editor>" %}

{% embed url="<https://docs.pentaho.com/pdia-10.2-install/multidimensional-data-modeling-in-pentaho/about-multidimensional-expression-language/mondrian-schema-element-reference>" %}

{% embed url="<https://mondrian.pentaho.com/documentation/schema.php>" %}

***

#### Updates

<details>

<summary>Mondrian 4</summary>

This section is for reference only.

There have been some major changes with the release of Mondrian 4:

* The XML schema format is not compatible between versions. Mondrian 3.x software would not
  \
  be able to read a Mondrian 4 schema, and Mondrian 4 software can read a Mondrian 3 schema
  \
  only because it recognizes that the schema is a legacy format and internally converts to Mondrian 4 format.
* The schema converter can handle most schemas but has the following limitations. It cannot
  \
  recognize uses of columns in expressions and convert them to Column elements.
* The VirtualCube element is obsolete. The equivalent in Mondrian 4 is a Cube that contains
  \
  multiple MeasureGroups.
* The AggName element is obsolete. In Mondrian 4 you define aggregate tables using the
  \
  MeasureGroup element (which is also used to define fact tables).
* The AggPattern element is obsolete. There is no direct way in Mondrian 4 to define a set of
  \
  aggregate tables by pattern-matching the names of tables and columns in the schema. You can
  \
  use the new aggregate table API to scan the schema and define aggregate tables.
* JPivot is no longer included with the release. Neither is there a mondrian.war file in the
  \
  distribution.
* The "high-cardinality dimensions" feature has been removed. There are better ways to support
  \
  dimensions that have large numbers of members.

</details>

#### Schemas

x

x