2 Replies Latest reply: Mar 18, 2017 11:37 AM by Massimo Grossi RSS

    Invalid Autogenerage count:-1

    Jack cai

      My data source is from oracle,the table name is THISFUNDASSET.

      L_DATEL_ID
      2017-01-041
      2017-01-04
      2
      2017-01-04
      3
      2017-01-04
      4
      2016-08-055
      2018-08-056

       

      my script is:

       

       

       

       

      LET varMinDate = NUM(PEEK('L_DATE',0,'THISFUNDASSET'));

      LET varMaxDate = NUM(PEEK('L_DATE',-1,'THISFUNDASSET'));

      TempCalendar:

      Load

      DATE($(varMinDate ) + ROWNO() -1) AS TempDate

      AUTOGENERATE$(varMaxDate ) - $(varMinDate ) + 1;

      MasterCalendar:

      Load

      DATE(TempDate) as Date,

      WEEK(TempDate) as Week,

      ..........................

       

       

      my problem is :

      Invalid Autogenerate count:-1:TempCalendar:Load DATE($(varMinDate ) + ROWNO() -1) AS TempDate AUTOGENERATE -+1;