Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Forecast Timer Series - could not find function "as.yearmon"

Received Response
71
Views
2
Comments
BenS
BenS Rank 3 - Community Apprentice
edited Aug 13, 2024 7:03PM in Oracle Analytics Forum

OBIEE 12c - Forecast Time Series Function

Have 3 columns in my analysis:  (1) Character Date format 'YYYY / MM', (2) Count (#  of users), and (3) Forecast

When I run the analysis I get the following error:

1. This is a date range from 2014 / 01 to 2016 / 01 in character string format

2. This is a summarized count of users from the fact table

3. This is the forcast column in the following format: 

FORECAST("- Fact - Google Analytics City Country Date"."Total Number Users", ("- City Country and Date GA Session Date"."GA Session Date Month" timeMonth),'forecast','modelType=arima;numPeriods=12;predictionInterval=70;')

If I remove the first column (the character date range) the analysis runs but of course doesn't show me anything of value.  I get the following error when I run the analysis as described:

[nQSError: 43119] Query Failed: Error(s): Error in obiee.Forecast.addOutputTimeColumns(dat, output, octr, dateFormat, : could not find function "as.yearmon"

I'm not sure why I get such an error when the same date string is used in the first column as used in the FORECASE function.  Any assistance would be appreciated.

Thanks...

Answers

  • User_DCUTA
    User_DCUTA Rank 1 - Community Starter

    At least from what i noticed, regarding the as.yearmon issue,i found that at the directory, \\~\Oracle_Home\bi\bifoundation\advanced_analytics\RInstaller\OBIEERPackage\OBIEEAdvancedAnalytics\R there is an R Program called obiee.timeseriesforecast.

    And within this program (obiee.timeseriesforecast),the packages ("zoo") and ("forecast") didnt seem to have been explicitly marked as required for the function "obiee.Forecast.addOutputTimeColumns", unlike the other function obiee.Forecast.freeTimeFormat in which "zoo" and "forecast" packages are marked as required. As it appears "as.yearmon" and "as.yearqtr" are features of the "zoo" package and is needed to evaluate the as.yearmon and as.yearqtr expressions.

    however when using the out-of-the-box "sample app", with a simlar dataset ("yearmon,"rev"), i didnt seem to have hit the as.yearmon error but with the similar dataset on our custom data, i hit the "as.yearmon" error, i could go past this error by including the require("zoo") and require("forecast") statements in the function "obiee.Forecast.addOutputTimeColumns" and then reinstalling the OBIEERPacakge for R.

    But still I was unable to get the forecast values as the forecast function returns zeros for them.

  • awei
    awei Rank 2 - Community Beginner

    I have same problem, would you try increase the month range with at least 5 years data.

    One of my case is only have 4 years history data, then forecast function give me all zeros, however when I given more years data , it seem worked.


    I don't known the reason.