Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Intro to Mondrian

Angus Miller
September 05, 2016

Intro to Mondrian

Mondrian is an open source Online Analytical Processing server (OLAP) written in JAVA

Angus Miller

September 05, 2016
Tweet

More Decks by Angus Miller

Other Decks in Technology

Transcript

  1. Whats is Mondrian…? Mondrian is an open source Online Analytical

    Processing server (OLAP) written in JAVA It supports the MDX (multidimensional expressions) query language It reads from SQL and other data sources and aggregates data in a memory cache
  2. What is OLAP OLAP is an acronym for Online Analytical

    Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
  3. Dimensions A Dimension is a structural attribute of a Cube

    that is a list of related names–known as Members For example, cities, regions and countries may make up a Region dimension Examples ▪ Department ▪ Location ▪ Region ▪ Product
  4. Measures Each cell of the cube holds a number that

    represents some measure of the business, such as sales, profits, expenses, budget and forecast. Collectively these are referred to as Measures. Examples ▪ Sales ▪ Expenses ▪ Inventory
  5. What is MDX SELECT {[Measures].[Unit Sales], [Measures].[Store Sales]} ON COLUMNS,

    {[Product].members} ON ROWS FROM [Sales] WHERE [Time].[1997].[Q2]
  6. Designing Mondrian Schema Mondrian schema is just an XML document

    Can create by hand season pro’s For the rest of us look at Pentaho Schema Workbench