MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 26: Mapping MDX to SQL Statements


 

ROWS Axis Expression

In a manner similar to that described in the section "COLUMNS Axis Expression," obtain the following tables R and Rprime:

Name Rank
Time.[All].1994.Jan 1
Time.[All].1994.Feb 2
Time.[All].1994.Mar 3
Time.[All].1994.Qtr2 4
Time.[All].1994.Qtr3 5
Time.[All].1994.Oct 6
Time.[All].1994.Nov 7
Time.[All].1994.Dec 8

Month Quarter Year Time.[All] Rank
Time.[All].1994.Jan Time.[All].1994.Qtr1 1994 Time.[All] 1
Time.[All].1994.Feb Time.[All].1994.Qtr1 1994 Time.[All] 2
Time.[All].1994.Mar Time.[All].1994.Qtr1 1994 Time.[All] 3
ALL() Time.[All].1994.Qtr2 1994 Time.[All] 4
ALL() Time.[All].1994.Qtr3 1994 Time.[All] 5
Time.[All].1994.Oct Time.[All].1994.Qtr4 1994 Time.[All] 6
Time.[All].1994.Nov Time.[All].1994.Qtr4 1994 Time.[All] 7
Time.[All].1994.Dec Time.[All].1994.Qtr4 1994 Time.[All] 8