Intro to Mondrian

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

Transcript

1. Intro to Mondrian @all4miller work at vulcanlabs.com
2. 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
3. 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.
4. 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
5. 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
6. Just think a pivot table!
7. Query Processing Mondrian Database SQL MDX SQL SQL SQL
8. What is MDX SELECT {[Measures].[Unit Sales], [Measures].[Store Sales]} ON COLUMNS, {[Product].members} ON ROWS FROM [Sales] WHERE [Time].[1997].[Q2]
9. DWH Design - Star Schema
10. DWH Design - Snowflake Schema
11. 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
12. Consuming Deploy to Pentaho BI server for hosted solution Integrate into your application via OLAP4J
13. Learning Resources Mondrian Site http://community.pentaho.com/projects/mondrian/
14. Thanks