MDX - SQL Server Analysis Services 2012 Cube Development - page 229

Internet Sales Amount YTD QTD

Mar-07 $485,574.79 $1,413,530.30 $1,413,530.30

Apr-07 $506,399.27 $1,919,929.57 $506,399.27

May-07 $562,772.56 $2,482,702.13 $1,069,171.83

Jun-07 $554,799.23 $3,037,501.36 $1,623,971.06

Jul-07 $886,668.84 $3,924,170.20 $886,668.84

Aug-07 $847,413.51 $4,771,583.71 $1,734,082.35

Sep-07 $1,010,258.13 $5,781,841.84 $2,744,340.48

Oct-07 $1,080,449.58 $6,862,291.42 $1,080,449.58

Nov-07 $1,196,981.11 $8,059,272.53 $2,277,430.69

Dec-07 $1,731,787.77 $9,791,060.30 $4,009,218.46

4. You could use the ParallelPeriod function to instruct SSAS to march a
specified number of timespans up the time hierarchy to obtain the needed