Mondrian MDX Introduction

Mondrian Introduction to MDX

MDX (Multidimensional Expression) is the language that constructs the query OLAP database; just like SQL is to build an operational relational database language.

MDX was pioneered by Microsoft as part of the 1997 Year system OLE DB for OLAP (ODBO) ;Mosha Pasuma Nsky is One of the MDX language designers;MDX is quickly used by other OLAP vendors as OLAP Query Language standard implementation, also includes Mondrian .

use MDX to query Online analytical processing (OLAP) data, calculate processing data, retrieve metadata properties, and more.

Select {[measures].[ Unit Sales]} on COLUMNS,

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

from [Sales]

where [TIME]. [1997]

Query "Sales" cube database "Unit Sales" dimension values, for all products that occur in the 1997, we can test by FoodMart sample data.

Mondrian Many of the Microsoft Analytics Service standard MDX expressions have been implemented to get more content here.

There are two ways to enter an MDX query on a jpivot JSP page:

· Enter jp:mondrianquery label

· entering MDX statements in the MDX Editor

using the MDX Editor:

· start Mondrian OLAP Services

· Browse the sample JSP file For example "JPivot PivotTable"

· Click the MDX button on the toolbar above the page to display the MDX Editor

· Enter the previous example MDX query statement here, click the Apply button

and display the following results table contents:

Mondrian MDX Introduction