IMPLEMENTATION OF MULTIDIMENSIONAL EXPRESSIONS (MDX) ON CUBE: A CASE STUDY OF BIRTH REGISTRATION DATA

The structured query language (SQL) is used for various operations on database; a multidimensional expression (MDX) is query language for analysis service. The MDX can be effectively used to browse the cube. Brion Larson defined as MDX as “programming language for OLAP Cube navigation” [1]. Brion Larson explains that MDX is very important for analysis as it has feature of advanced mathematics and formulas. Furthermore, MDX also allows us to navigating through the dimensions and hierarchies of OLAP cube [1]. All these features are not part of T-SQL and hence it is very important for us to use MDX script for analysis purpose in data warehouse environment. In the previous research work, various operations on cube were shown using design mode [2] [3]. In the paper, different analytical scenarios and respective MDX queries are discussed on birth registration data cube.