MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 26: Mapping MDX to SQL Statements
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 |