Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Next in This Series
This tutorial introduced MDX by exposing and discussing fundamental concepts and terms. We explored basic MDX syntax, with practical examples of the use of the language to return information from multidimensional data sources. Using illustrated examples, we covered the return of information about numbers, basic conversion functions, building expressions that return information about related members based on using the current member as a starting point, and the use of simple conditional tests and comparisons in basic expressions.
Upcoming tutorials deal with more involved MDX concepts, and with MDX queries, as opposed to MDX expressions, such as those we explored in this first tutorial. MDX queries can select many values from cubes, as opposed to the single values generated by separate MDX expressions. We'll discuss the purposes of MDX queries as well as new terms that come into play.
We'll create basic MDX queries to get a good feel for the steps and considerations involved in query creation. We'll also explore the process of returning values with MDX, focusing on the specification of dimensions. Moreover, we'll revisit member reporting and expose further means of calculating members based on the current member, as well as the process of selecting empty members to suit various needs.