5 Replies Latest reply on Dec 15, 2016 6:41 PM by Robert Brooks

    Forecasting tool issues

    Robert Brooks

      I am currently working in Data Visualization Desktop and am trying to use the forecasting tool.

       

      I have downloaded the R package that is required for it and am making sure that when I use it that I have a date object.

       

      I have created a forecast calculation: FORECAST("Sales", ("Order Year", "Order Month"), 'forecast','numPeriods=12').

      When I go to use this formula, I receive the error:

      Odbc driver returned an error (SQLExecDirectW).
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
      (HY000)
      State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
      (HY000)
      State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
      (HY000)
      State: HY000. Code: 47092. [nQSError: 47092] The value of R_EXECUTABLE_PATH is set to C:\ProgramFiles\R\R-3.1.1\bin\x64\R.exe which is invalid. (HY000)
      SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT
      0 s_0,
      XSA('weblogic'.'Sample Superstore')."Columns"."Order Date" s_1,
      FORECAST((XSA('weblogic'.'Sample Superstore')."Columns"."Sales"),(XSA('weblogic'.'Sample Superstore')."Columns"."Order Date"),'forecast','numPeriods=3;') s_2,
      REPORT_AGGREGATE(XSA('weblogic'.'Sample Superstore')."Columns"."Sales" BY ) s_3,
      TRENDLINE(aggregate(XSA('weblogic'.'Sample Superstore')."Columns"."Sales" BY XSA('weblogic'.'Sample Superstore')."Columns"."Order Date"),(XSA('weblogic'.'Sample Superstore')."Columns"."Order Date") BY (),'LINEAR','MODEL') s_4,
      TRENDLINE(aggregate(XSA('weblogic'.'Sample Superstore')."Columns"."Sales" BY XSA('weblogic'.'Sample Superstore')."Columns"."Order Date"),(XSA('weblogic'.'Sample Superstore')."Columns"."Order Date") BY (),'LINEAR','SEQUENCE') s_5,
      XSA('weblogic'.'Sample Superstore')."Columns"."Sales" s_6
      FROM XSA('weblogic'.'Sample Superstore')
      FETCH FIRST 5000001 ROWS ONLY

       

      Does anyone have any suggestions or how I could fix the executable path which seems to be causing the problem?

       

      Thanks.