You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Replicating Excel FORECAST.ETS Functionality in EPM Using @TREND (TES)

in Planning

Hi All, 

I have been analyzing the behavior of the Triple Exponential Smoothing (TES) method in EPM using the @TREND function.

In Excel, the FORECAST.ETS function automatically optimizes and applies the smoothing parameters—Alpha (level), Beta (trend), and Gamma (seasonality)—to generate forecast values. 

However, in Oracle EPM, when using @TREND with TES, these parameters must be explicitly defined. If not provided, the system applies default values. Due to this difference in implementation, the forecast results in EPM do not exactly match those generated by Excel, and some level of variance is inevitable. 

My question is:
Is there any approach or functionality within Oracle EPM that can replicate Excel’s

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!