| MDX stands for Multidimensional Expressions serve | | | | language is concerned, it could be possible when the |
| the purpose of helping the OLAP databases working | | | | group of SQL Server engineers along with Mosha |
| as a query language. It is much similar to SQL which is | | | | Pasumansky decided to do the task in a positive |
| known as a query language for relational databases. | | | | manner. |
| This language works for different calculation purposes | | | | MDX include six major data types. These types can |
| with the help of syntax that is similar to spreadsheet | | | | be defined in the following way: |
| formulas. | | | | Scalar: Scalar can be defined in the form of a string or |
| OLAP cubes store the multidimensional data that is | | | | a number. As far as the specification of this data type |
| queried and manipulated by a specialized syntax | | | | is concerned, the task could be done in the way, for |
| provided by the MultiDimensional eXpressions (MDX) | | | | example, number 5 or string "OLAP." MDX function |
| language. Although some of these can be translated | | | | can return it, e.g. UniqueName (sting), Aggregate |
| into traditional SQl, the requirement of the Synthesis of | | | | (number), Value (number or string) etc. |
| clumsy SQL expressions is invaluable for all MDX | | | | Dimension/Hierarchy: It is very easy to explain the |
| expressions whether it is very simple or the difficult | | | | dimension. It is, actually, a dimension of a cube. As a |
| one. MDX is incorporated with a number of stunning | | | | whole, it works as a main organizer of attribute and |
| features that can be helpful for various IT | | | | measure information in a cube. |
| organizations. These days, most of the OLAP vendors | | | | Level: The level that is noticed in the Dimension |
| prefer to use the MDX. The popularity of this query | | | | hierarchy is referred to as the level, which is a data |
| language has made it a perfect and standard | | | | type of query language. The unique name, e.g. [Month], |
| alternative for OLAP systems. | | | | [Fiscal], [Time] is the source of specifying it. |
| Microsoft was the first which took an initiative to | | | | Member, tuple and set are three other primary data |
| introduce the MDX as part of the OLE DB for OLAP | | | | type of MDX. |
| specification in 1997. As far as the invention of this | | | | |