MDX-Query
Multidimensional Expressions (MDX) is a query language for OLAP databases. Much like SQL, it is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas.
NOTE: OLAP tools enable users to analyze multidimensional data interactively from multiple perspectives.OLAP consists of three basic analytical operations:
1) consolidation (roll-up)
2) drill-down
3) slicing and dicing
1) Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions.
For example, all sales offices are rolled up to the sales department or sales division to anticipate sales trends.
2) Drill-down is a technique that allows users to navigate through the details.
For example, users can view the sales by individual products that make up a region's sales.
3) Slicing and dicing is a feature whereby users can take out (slicing) a specific set of data of the OLAP cube and view (dicing) the slices from different viewpoints. These viewpoints are sometimes called dimensions.
MDX Video Tutorial
NOTE: OLAP tools enable users to analyze multidimensional data interactively from multiple perspectives.OLAP consists of three basic analytical operations:
1) consolidation (roll-up)
2) drill-down
3) slicing and dicing
1) Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions.
For example, all sales offices are rolled up to the sales department or sales division to anticipate sales trends.
2) Drill-down is a technique that allows users to navigate through the details.
For example, users can view the sales by individual products that make up a region's sales.
3) Slicing and dicing is a feature whereby users can take out (slicing) a specific set of data of the OLAP cube and view (dicing) the slices from different viewpoints. These viewpoints are sometimes called dimensions.
MDX Video Tutorial
0 comments: