Querying Data Warehouses
- 5.1k Downloads
Just as SQL is a language for manipulating relational databases, MDX (Multi-Dimensional eXpressions) is a language for defining and querying multidimensional databases. Although at first sight it may appear that MDX resembles SQL, they are significantly different from each other. While SQL operates over tables, attributes, and tuples, MDX works over data cubes, dimensions, hierarchies, and members (at the instance level). MDX is a de facto standard supported by many OLAP tool providers.
KeywordsProduct Category Calculated Measure Monthly Sale Order Date Temporary Table
Unable to display preview. Download preview PDF.