1 Reply Latest reply: Jul 2, 2011 7:51 AM by Erich Shiino RSS

    Set analysis code error

      Hi All,

      I have attached a picture about my problem statement.

      Hope I was able to pictorially explain whats going wrong.

       

      Please help,

       

      Regards,

      Bikash

        • Set analysis code error
          Erich Shiino

          Hi, Bikash

           

          Sometimes, set analysis does not handle the date format very well.

          I suggest you use a auxiliary field for the DW date as an integer.

          In the script, where you have something like:

          Load

          DW_LOAD_DATE,

          ... ETC

           

          , include another line

          load

          DW_LOAD_DATE,

          num(DW_LOAD_DATE) as nDW_DATE,

          ... etc

           

          Your vConvStart and vConvEnd should get max and min of this new field

          =min(nDW_DATE) and = max(nDW_DATE)

           

          Your set analysis should also change to compare nDW_DATE instead of DW_LOAD_DATE

          hope this helps,

           

          Erich