Submitting from Free-Form Grid with Scaling Options Enabled

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting; Oracle Essbase

Starting in Smart View 23.200, when attempting a free-form submit with scaling options enabled, and using the Submit button in the Smart View ribbon or provider ad hoc ribbon, the following warning is shown:

You are in free-form mode. Perform a Refresh before Submit.

Click the Details button, and the following note is displayed:

Free-form submit is not allowed when scaling is enabled.

Using the Submit Data Without Refresh or Submit Data Range options on the Submit button in the provider ad hoc ribbon, the following warning is shown:

To submit scaled data, refresh the grid and submit. You are attempting free-form submit; data will not scale per scaling options and will be submitted as is. Do you want to continue?

If you decide to submit after viewing this message, then the data will be submitted as is.

Additionally, for any free-form submit, a status is shown in the Excel status bar until the submit processing is completed (this status remains depending on the processing time). The status lets you know that the values are being submitted as is, without considering the dirty status or scaling options set.

Note:

For EPM Cloud sources only:

  • To take advantage of this feature, the Smart View Ad Hoc Behavior option in your application must be set to Standard.

  • This feature applies to ad hoc grids in free-form mode and flex forms.