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

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
-
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.
0 -
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.
0