Introduction to Mondrian MDX and mondrianmdx

Introduction to Mondrian MDX and mondrianmdx

Introduction to Mondrian MDX

 

 

MDX (multidimen1_expression) is the language used to construct and query OLAP databases, just as SQL is used to build and operate relational databases.

MDX was the first developed by Microsoft and is part of the 1997 system ole db for OLAP (ODBO). Mosha Pasumansky is one of the MDX Language designers. MDX is soon implemented by other OLAP vendors as the OLAP query language standard, it also includes Mondrian.

 

You can use MDX to query OLAP data, compute and process data, and retrieve metadata attributes.

 

Select {[Measures]. [Unit Sales]} on columns,

{[Product]. [All Products]} ON ROWS

From [Sales]

Where [Time]. [1997]

 

Query the dimension value of "Sales" cube Database "Unit Sales". We can test the Foodmart sample data for all products that occurred in 1997.

 

Mondrian has implemented many Microsoft's standard MDX expressions for analysis services. More information can be obtained here.

 

There are two ways to enter MDX to query on the July JSP page:

· InputJp: mondrianQueryTag

· InMDXEnter the MDX statement in the editor.

Use the MDX Editor:

· Start the Mondrian OLAP Service

· Browse the sample JSP file, for example "jsf-appsttable"

· Click on the toolbar at the top of the pageMDXButton to display the MDX Editor

· Enter the following MDX query statement and clickApplyButton

And display the following result table content: