4 Replies Latest reply: Mar 21, 2016 5:49 AM by Swetha More RSS

    Error while creating a calendar table

    Swetha More

      Dear Experts,

       

      I am creating a Fiscal Calendar table for YTD calculation. Here is the script for the calendar creation:

       

      Set vFM = 10 ;        // First month of fiscal year

       

      Calendar:

      Load

        Dual(fYear-1 &'/'& fYear, fYear)  as FYear,          // Dual fiscal year

          Dual(Month, fMonth)                as FMonth,      // Dual fiscal month

                *;

      Load

        Year + If(Month>=$(vFM), 1, 0) as fYear,          // Numeric fiscal year

          Mod(Month-$(vFM), 12)+1        as fMonth,          // Numeric fiscal month

                *;

      LOAD

        DATE(date_invoice) as date_invoice,

          year(date_invoice) as Year,

          Month(date_invoice) as Month,

          Monthname(date_invoice) as MonthYear

      Resident account_invoice;

       

       

      Everytime i try to load, it throws an

      The following error occurred:

      Table not found

      The error occurred here:

      LOAD DATE(date_invoice) as date_invoice, year(date_invoice) as Year, Month(date_invoice) as Month, Monthname(date_invoice) as MonthYear Resident account_invoice

      Data has not been loaded. Please correct the error and try loading again.

       

       

      Could somebody please point out what could be the potential problem?

       

      Thanks

      Swetha