Symptom
When trying to create a formula within a story using the 'Simple Moving Average' (SMA) function, this generates a warning 'Function SMA is not supported in stories at this time'
Environment
SAP Analytics Cloud
Reproducing the Issue
- Create a story
- Add a formula and attempt to use the 'Simple Moving Average' (SMA) function.
- When trying to save this formula the message 'Function SMA is not supported in stories at this time' is generated
Cause
- As seen within the SAP Analytics Help page within the 'Business Functions' section there is a notification "These functions are available only in Modeler."
- Therefore at this time the Business Functions such as the 'Simple Moving Average' (SMA) can only be used as a formula within the modeler for the model itself and not within a story.
Resolution
- At this time there is no plan to add the SMA functionality to the story however if this is a required feature it would be recommended to submit an enhancement request to raise the priority of this feature to be considered for a future version.
- Reference the KBA '2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?' for the steps to submit an enhancement request.
Keywords
Logic Limitation script , KBA , LOD-ANA-PL , Planning , Problem
Product
SAP Analytics Cloud 1.0