MDXqueries example
MDX Query Language is used to retrieve information stored in OLAP Cube created in various technologies like Microsoft SQL Server Analysis Services(SSAS), Oracle, Tera data, etc. Key difference between MDX and T-SQL is MDX Query build Multidimensional View of the data, where T-SQL builds Relational View. SQL Query designed to handle only two dimension while processing tabular data . 1. General : 1. Top Product Revenue select [Measures].[Cout] on columns , non empty TOPCOUNT ( [Product].[Model Name]. members ,3, [Measures].[Cout]) on rows from [sales_esp] ; 2. Top month Revenue select [Measures].[Cout] on columns , non empty TOPCOUNT ([Dim Temps].[Month]. members ,3, [Measures].[Cout]) on rows from [sales_esp] ; 3. Top year Revenue select [Measures].[Cout] on columns , non empty ...