MDX - Counting Members at a Hierarchy Level
Counting Members in an MDX Query
MDX is a challenging query language. It is completely different to the SQL query language despite having a SELECT statement!
MDX queries are all about hierarchies, measures and members and when it comes to carrying out tasks that are simple in SQL it may not be so simple in MDX.
Most of the time when we work with MDX queries we are interested in bringing out aggregate values that are stored in our cube, but occasionally we may want to derive values from the stored cube data.