1.

What Is Mdx And Its Usage?

Answer»

MDX is an acronym for ‘Multi-Dimensional Expressions,’ the standard query language introduced by Microsoft SQL OLAP Services. MDX is an IMPERATIVE part of XML for analysis API, which has a different STRUCTURE than SQL.

A basic MDX query is:

SELECT {[Quantity].[Unit Sales], [Quantity].[STORE Sales]} ON COLUMNS,

{[Product].members} ON ROWS

FROM [Sales]

WHERE [Time].[1999].[Q2]

MDX is an acronym for ‘Multi-Dimensional Expressions,’ the standard query language introduced by Microsoft SQL OLAP Services. MDX is an imperative part of XML for analysis API, which has a different structure than SQL.

A basic MDX query is:

SELECT {[Quantity].[Unit Sales], [Quantity].[Store Sales]} ON COLUMNS,

{[Product].members} ON ROWS

FROM [Sales]

WHERE [Time].[1999].[Q2]


Discussion

No Comment Found

Related InterviewSolutions