Data forms are grid displays that enable you to enter data into the database from Excel and to view and analyze data or related text. Certain dimension member values are fixed, giving you a specific view into the data.
Using Smart View, you can work with Planning, Financial Management, and Hyperion Enterprise data forms in Excel.
Excel worksheets are always protected to prevent entering data for read-only cells. Therefore, some Excel functions, such as AutoSum and F9, are disabled. |
When you work with data forms in Smart View:
You can modify data values but not the form structure in data forms.
Values submitted to the database from Excel must be non-formatted data.
If a data form is currently loaded in Excel and the administrator changes the data form definition on the server side, Oracle recommends that you close the data form and reload it. This action ensures that the newest data form definitions are displayed.
Multiple levels in an outline are displayed differently in Smart View than pages on the Planning Web application. Smart View displays up to four levels, while the Web application displays up to two levels.
If a Planning administrator hides a dimension in the row axis of a Planning data form, this dimension does not display in the row header of the data form in Smart View.