Oracle Smart View for Office offers two new options for submitting data:

Note that you can use the Submit Data Without Refresh and Submit Data Range options to submit cell data from cells that were modified by a user who does not have Smart View installed.

In the Oracle Smart View for Office User's Guide, see “Using the Submit Data Options” for more information.

When connected to Essbase and Oracle Hyperion Provider Services 11.1.2.4 or later, the POV toolbar and pivoting behavior is enhanced as follows:

In prior releases, only one member in a dimension could be pivoted from the grid to the POV, and from the POV to the grid. Also in prior releases, Essbase only supported having at least two dimension on the POV toolbar.

In release 11.1.2.5.400 and later, you can customize the extension update process so that Smart View end users can control when they install, update and remove extensions. To enable this functionality, the Smart View administrator configures attributes in the UpdateList.xml manifest file to control the options available to the users. If the administrator does not configure these attributes in UpdateList.xml, extensions will continue to be updated using the existing Auto-Update process.

In releases earlier than Smart View 11.1.2.5.400, extensions were updated using the Auto- Update process. To update extensions with Auto-Update, Smart View end users go to the Extensions tab of the Options dialog box and click the Check for updates link or select the Check for updates when Microsoft Office starts check box to initiate extension updates. For all extensions, if any updates were available, they were retrieved and installations were automatically initiated.

There are two types of extensions that can be installed on a Smart View client machine:

The Smart View administrator configures the UpdateList.xml file to specify the list of provider and per-user extensions available to end users along with options for installing, updating, and removing them. Additionally, per-user extensions can also be configured to display an indicator for required extensions and does not force the installation. The Smart View end user then accesses the Options dialog box and installs, updates, or uninstalls the extensions that are available to him or her in the Extensions tab.

To configure provider and per-user extension installation, uninstallation, and updating, complete the procedure “Configuring Manual Extension Updates” in the Oracle Smart View for Office User's Guide.

If you do not want to make changes to the extension update process, you may refer to “Configuring Auto-Update Extensions” in the Oracle Smart View for Office User's Guide for information on the structure of the XML and examples, but you do not need to take any further action.

For instructions on installing, updating, and removing extensions in Smart View, end users can refer to the procedure topics in “Extensions” in the “Smart View Options” chapter of the Oracle Smart View for Office User's Guide.

When an issue arises while using Smart View that you cannot resolve on your own, you can use the new Smart View Diagnostic tools in the Diagnostics group in the Smart View ribbon to create and collect log files and screenshots to send to Oracle Support. When you are finished collecting diagnostic data, you use the diagnostic tools to zip up the files. Then you transmit the ZIP file to Oracle Support for analysis. The log files and screenshots are used by Oracle Support to troubleshoot and resolve your issue.

You can customize certain features of Smart View Diagnostic tools; for example:

See the “Smart View Diagnostics” chapter of the Oracle Smart View for Office User's Guide for more information on the Diagnostics tools.

The Member Selection dialog box for Oracle Hyperion Business Rules and for modifying user variables on forms is changed in this release, and is now the same as the standard Smart View Member Selection dialog box accessed from the data provider ribbons. With this new dialog box, performance is improved when selecting members for Business Rules or modifying user variables, providing a consistent user experience across the product.

In prior releases, the Member Selection dialog box for Oracle Hyperion Business Rules had a different look-and-feel from the standard Member Selection dialog box, even though the fields and controls were generally the same.

This feature requires Planning 11.1.2.4 or later.

An Essbase administrator can require that users specify a user name and a password when logging on to the data source to access drill-through reports. When launching a drill-through report in Smart View, the user name and password fields are now displayed if they are required to access the drill-through report. If a user name and password are not required, then these fields are not displayed.

When defining the filter expression for views in View Designer, sometimes the data to choose from in the Value Selector is exceedingly long. To accommodate loading large amounts of data in the Value Selector, Smart View presents values in groups. In the Value Selector, you can scroll and make selections from the first group shown, then click More to view and make selections from the next group. You can continue clicking More until you have viewed and made selections from the entire data list.

Prompts enable users to specify criteria that determines the content of the view that they are inserting. When editing prompts, depending on how the prompt was set up, you may be selecting data directly from a drop-down list on the Prompt Selector. You may also be picking values from the Value Selector dialog box. Sometimes the data to choose from in the Value Selector is exceedingly long. To accommodate loading large amounts of data in the Value Selector, Oracle Smart View for Office presents values in groups. In the Value Selector, you can scroll and make selections from the first group shown, then click More to view and make selections from the next group. You can continue clicking More until you have viewed and made selections from the entire data list.

The Measure Label element represents the labels for all the Measures columns in the Measures edge of the View Designer. If you are working with a pivot table view that has the pivot table display style, you can now reorder the Measure Label element within the Column edge, and you can now move the Measure Label to any edge except the Measure edge. Oracle recommends experimenting with moving the Measure Label element to another edge, or reordering it within the Column edge, to create a more readable pivot table layout.

The Sheet Information dialog box in Excel now presents consistent information across Oracle Essbase, Oracle Hyperion Planning, and Oracle Hyperion Financial Management providers, including connection status and other information. See “Sheet Information” in the Oracle Smart View for Office User's Guide for more details.