In Smart View, you create Smart Forms by saving ad hoc grids that contain grid labels and business calculations. Smart Forms are saved to Oracle Planning and Budgeting Cloud Service.
To create a Smart Form:
Follow the steps in Starting Ad Hoc Analysis to create an ad hoc grid.
Alternatively, open an Oracle Planning and Budgeting Cloud Service form and, from the Planning ribbon, click Analyze to convert the form to an ad hoc grid.
Add grid labels and business calculations (in the form of Excel formulas and functions), to the ad hoc grid.
After you have added grid labels and business calculations to an ad hoc grid, in the Planning Ad Hoc ribbon, click
.In the Save Grid As Smart Form dialog box:
In Grid Name, provide a name for the Smart Form.
In Grid Path, browse to the location where you want to store the Smart Form on Oracle Planning and Budgeting Cloud Service.
You can also type a new folder name. The folder appears under the application in the Smart View Panel.
Optional: Select Submit Formatting to save any custom Excel formatting changes that have been applied to the grid.
See Saving Native Excel Formatting to Planning for additional notes and guidelines about saving formatting in Oracle Planning and Budgeting Cloud Service ad hoc grids and forms.
In the Smart View Panel, Smart Forms are designated with the
icon.