Advanced Predictions: Ability to Generate Advanced Predictions for Dynamic Calc Members

You can now generate Advanced Predictions for Dynamic Calc members.

Applies To: FreeForm, Planning

To define Advanced Predictions for Dynamic Calc members: Include the Dynamic Calc members in the Advanced Prediction slice definition, as either the Target slice or the Future Data slice.

The members must be in Scenario, Version, Plan Element or relevant dimensions associated with the UDA HSP_DYN_PREDICT.

To view Advanced Predictions for Dynamic Calc members when you load a form: Because predicted values can't be stored for Dynamic Calc members, you can specify to generate predictions at the parent level at run time and load the form with predicted values, by using a form option and by associating members in Scenario, Version, Plan Element or relevant dimensions associated with the UDA HSP_DYN_PREDICT. 

To specify whether to perform a prediction when the form loads: In the Form Designer, in the Prediction Options settings, select Prediction for Dynamic Calc. A validation confirms that the HSP_DYN_PREDICT UDA is associated with the members on the form.

Selecting Explain Prediction (either by right-clicking a cell or from the Actions button on the form) on the dynamic calc member associated cell intersections renders predicted data in the chart.

Business Benefit: This enhancement allows you to perform Advanced Predictions at any level in the hierarchy. 

  • Generating predictions at the parent level improves accuracy, especially when data is missing or not accurate in lower levels of the hierarchy. 
  • Prediction accuracy is improved, because rather than predicted data getting aggregated at the parent level, the parent level is also predicted.
    For example, predicting for overall Operating Expenses might be better than predicting each of the expense categories under Operating Expenses such as Travel, Entertainment, and Staff Welfare, because the child member data could be sparse.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

  • This feature is supported only for Dynamic Calc members; it is not supported for Dynamic Calc and Store members.
  • Dynamic Calc parent level values can't be stored or exported.
  • You can use a Groovy script to allocate the Dynamic Calc parent-level predicted values to level zero members. 
  • HSP_DYN_PREDICT can be associated with non-aggregating sparse dimensions such as Scenario, Version, Plan Element or similar dimension that is used to store predicted values.
  • Generating predictions for Dynamic Calc members is not supported in ad hoc grids.

Key Resources