MDX - How to define the default measure in a query?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sphengle
    New Member
    • Oct 2008
    • 3

    #1

    MDX - How to define the default measure in a query?

    I'm a complete newb to MDX. I am reading this article and simultaneously writing similar MDX queries against my own data.

    Article...


    In the article he has a query...

    SELECT
    Years.MEMBERS ON COLUMNS,
    Regions.Contine nt.MEMBERS ON ROWS
    FROM Sales

    Notice that it doesn't specify the measure. The "default" is used.

    The question is, how do you change the query in order to specify the precise measure of interest? I've tried loads of things without success.

    Thanks
Working...