Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Multidimensional Expression and its use in SAP BPC
MDX is a query language developed by Microsoft to query OLAP cubes. In OLAP cubes, data is structured as multidimensional. You have a fact table in middle and dimension tables surrounding fact tables. MDX is used to query STAR schema cubes like this and generate results for different purposes.
MDX query language is bit similar to SQL with few fundamental differences like:
In MDX queries, it can have 0, 1, 2,3,4…up to 128 query axes in the SELECT statement. Each axis behaves in exactly the same way, unlike SQL where there are significant differences between how the rows and the columns of a query behave.
MDX syntax distinguishes sets by surrounding tuples or members with braces, etc.
Example
Example of SELECT MDX query −
SELECT
{ [Measures].[Sales Amt],
[Measures].[Tax Amt] } ON COLUMNS,
{ [Date].[Fiscal].[Fiscal Year].&[2012],
[Date].[Fiscal].[Fiscal Year].&[2013] } ON ROWS
FROM [Sample Works]
WHERE ( [Region].[Southwest] ) For more details, you can navigate to Microsoft site link −
303 Views
