This content has been marked as final. Show 2 replies
AWM 10g had a UI screen for defining forecast measures that, under the covers, generated an OLAP DML program to call the built-in 'Geneva Forecasting Engine'.
Unfortunately this screen did not make it into AWM 11g, so you would need to write the OLAP DML yourself to do the forecast and populate the appropriate VARIABLE objects. You can then call the OLAP DML program directly or add it to a "cube script" defined in AWM. While this may seem like a backwards step from 10g, my personal opinion is that coding the forecast yourself will give you more control and (ultimately) better performance than the primitive support available in AWM 10g.
The 10g AWM support was based on a handful of OLAP DML commands:
<li>FCOPEN function -- Creates a forecasting context.
<li>FCSET command -- Specifies the forecast characteristics.
<li>FCEXEC command -- Executes a forecast and populates Oracle OLAP variables with forecasting data.
<li>FCQUERY function -- Retrieves information about the characteristics of a forecast or a trial of a forecast.
<li>FCCLOSE command -- Closes a forecasting context.
Search for "Forecasting Programs" in the OLAP DML Reference guide to see details. Here is an example (copied from the documentation) so that you can see what such a program would look like. You would need to change the variable names to match the variables in your cubes.
DEFINE autofcst PROGRAM PROGRAM " Using the Automatic forecasting method " Suppose you want to create a forecast from the data in " an input variable named fcin1 that is dimensionsed by " a time dimension named timedim. " " Open a forecasting context hndl = FCOPEN('MyForecast') " Initialize the target variables fcout1 = NA fcseas1 = NA fcsmseas1 = NA " Specify that the forecast be of the AUTOMATIC type fcset hndl method 'automatic' " Execute the forecast FCEXEC hndl time timedim INTO fcout1 - seasonal fcseas1 smseasonal fcsmseas1 backcast fcin1 " Close the forecasting context FCCLOSE hndl END
THanks David for the inputs. It is very unfortunate to miss this in the UI. I am not that good at the forecast funtions that you mentioned. I have questions regarding those.
Q1. What is a the object that is mentioned in 'MyForecast' specified in the below piece of code? Is that a Cube/Measure or the new measure that we create for forecast values ?
" Open a forecasting context
hndl = FCOPEN('MyForecast')
Q2. Based on the below FCEXEC st, where do am I specifying the name of the measure that I want to use ? and what is the measure that It is trying to populate the forecast values.
" Execute the forecast
FCEXEC hndl time timedim INTO fcout1 -
seasonal fcseas1 smseasonal fcsmseas1 backcast fcin1
Q3. Once after the runing this dml program, how can I see the forecast values in the UI, on what measure ?
Can u please answers these questions so that I can try on with OLAP DML.