MDX DateAdd function over a set of tuples -

i trying create set of dates using dateadd() function getting errors while trying pass set of tuples parameter. below code returns member looking set of new dates.

with member [eff inj dt] dateadd("m",12, [injury date].currentmember)

select {[eff inj dt]} on columns, [injury date].[date].members on rows [wvwc data cube froi sroi] 

i have following attempt:

  set [eff inj dt]  dateadd("m",12, [injury date].currentmember)  select {[eff inj dt]} on columns, [injury date].[date].members on rows [wvwc data cube froi sroi] 

using adv works if want move 12 members forward can navigate in several ways.

try following. should return date 12 days ahead of currentmember:

with      member [measures].[eff inj dt]         [date].[calendar].currentmember.lead(12).membervalue select      {[measures].[eff inj dt]}  on 0,     {[date].[calendar].[month].&[2006]&[4].children} on 1 [adventure works]; 

looks want return date 12 months in future.

so first need year corresponds currentmember via ancestor function > go forward equivalent date using cousin function following:

with      member [measures].[eff inj dt]     cousin(         [date].[calendar].currentmember,          ancestor(             [date].[calendar].currentmember,              [date].[calendar].[calendar year]).lead(1)             ).membervalue    select      {[measures].[eff inj dt]}  on 0,     {[date].[calendar].[month].&[2006]&[4].children} on 1 [adventure works]; 

adapting scenario , assuming injury date multi-level user hierarchy' contains level calledcalendar year` following:

with      member [measures].[eff inj dt]         cousin(             [injury date].currentmember,              ancestor(                 [injury date].currentmember,                  [injury date].[calendar year]).lead(1)                 ).membervalue    select      {[measures].[eff inj dt]}  on 0,     {[injury date].[date].members} on 1 [adventure works]; 

---

edit

via vba tools have following in adv wrks:

with      member [measures].[eff inj dt]       dateadd(       "m",       12,       [date].[calendar].currentmember.membervalue        )   select      {[measures].[eff inj dt]}  on 0,     {[date].[calendar].[month].&[2006]&[4].children} on 1 [adventure works]; 

adapted scenario:

with      member [measures].[eff inj dt]     dateadd(     "m",     12,     [injury date].currentmember.membervalue      )   select      {[measures].[eff inj dt]}  on 0,     {[injury date].[date].members} on 1 [adventure works];