Multi Dimensional Data - MDX

Data System Architecture

About

MDX is a standardized query and calculation language for multidimensional databases such as:

  • Essbase,
  • Microsoft Analysis Services,
  • and SAP BW.

Example

SELECT [Year].Children ON ROWS, 
[Profit].Children ON COLUMNS 
FROM [Sample].[Basic] 
WHERE [Actual]




Discover More
Data System Architecture
Cube - Multi-dimensional query (OLAP query)

An multi-dimensional query is a query that runs against a multi-dimensional structure (ie cube). It is also known as: an OLAP query. a business query multi-dimensional query are analytics query...
Essbase Overview
Essbase - MDX

in Essbase. When creating formulas for an aggregate storage database, you use MDX. When the aggregate storage option was added to Essbase, MDX was chosen over the Calc Scripting Language in order to...
Data System Architecture
Relational Data Modeling - View selection problem (recommending the best aggregation tables) - Data Warehousing

The View Selection Problem (VSP) is an NP-Complete problem. Challenges: Design Which materializations to create? Populate Load them with data Maintain Incrementally populate when data changes...



Share this page:
Follow us:
Task Runner