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

    Rowno() / Synthetic dimensions and set anaylises

    Ben Romeijn




      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 $(= ..)





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