1 Reply Latest reply: Jul 17, 2014 10:23 AM by Srikanth P RSS

    Rowno() / Synthetic dimensions and set anaylises

    Ben Romeijn

      Hi,

       

       

      I created a synthetic dimension (1 to 10). Based on a startdate I would like to have rolling period.

      So startdate + 1,startdate + 2.

       

      From what I know you cannot use a synthetic dimension in a set analysis. So I tried to use Rowno() instead.

       

      This expression workfine whitout re-calculating it $(= ..)

      $(=date(addmonths(makedate(2013,01),RowNo()),'YYYYMM'))

       

       

      (Count({1<PARTY_ID=Cohort_1::PARTY_ID,

      YEARMONTH={'$(=date(addmonths(makedate(2013,01),RowNo()),'YYYYMM'))' } >}PARTY_ID)

       

      Thanks,

       

      Ben