10 Replies Latest reply on Dec 15, 2016 6:43 PM by Robert Brooks

    Query Errors when using Forecasting tool

    Robert Brooks

      I am currently working with a dataset in .xlsx format and am trying to use the forecast tool to forecast sales over time. I have sales as a measure and order date as a date but when I try to use the forecast tool (whether by dragging it in or manually creating a calculation), I keep getting a query error. Does anyone know a solution to this?

       

      I am using Oracle's Data Visualization Desktop tool.

       

      EDIT:

       

      I have attached an image of the measures/attributes I am using as well as the query error that I am receiving. I also downloaded a forecasting example from (https://sites.google.com/site/oraclebipublicstore/downloads) which also gives me similar querying errors.

       

      query error.PNGquery error 2.PNGquery error 3.PNG

       

      Message was edited by: 9d096598-d1ea-44b5-b6e0-c28377afbcfc at 3:00PM