Table of Contents:
Oracle Smart View for Office offers two new options for submitting data:
Submit Data Without Refresh—Submit modified cells, also called dirty cells, from Oracle Essbase, Oracle Hyperion Planning Ad Hoc, and Oracle Hyperion Financial Management Ad Hoc without first refreshing. This functionality was previously only available for Essbase.
Submit Data Range—Select and then submit contiguous and non-contiguous single cells and cell ranges from Essbase, Planning Ad Hoc, and Financial Management Ad Hoc. Only cell data from the selected cells is submitted. If there are dirty cells on the sheet outside the range of selected cells, their changed value is not submitted.
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 184.108.40.206 or later, the POV toolbar and pivoting behavior is enhanced as follows:
Multiple members can now be pivoted from the grid to the POV toolbar.
Multiple members can now be pivoted from the POV toolbar to the grid.
A single dimension can now remain on the POV toolbar.
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 220.127.116.11.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 18.104.22.168.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:
Provider extensions. Extensions that are dependent on, or integrated with, Oracle components are provider extensions. Examples are the Oracle Hyperion Disclosure Management and Oracle Hyperion Financial Reporting extensions. Provider extensions can be configured as required extensions.
Per-user extensions. Extensions that are installed in the user’s application data folder. These extensions may or may not be dependent on Oracle components. Additionally, per-user extensions can also be configured as required extensions.
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:
Hide data values in an Office document.
Hide member names in an Office document.
Direct the diagnostics output files to a folder other than the default.
Allow automatic screenshots for each warning or error message that is displayed.
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 22.214.171.124 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.
Use the Cumulative Feature Overview tool to create reports of new features added in prior releases. This tool enables you to identify your current products, your current release version, and your target implementation release version. With a single click, the tool quickly produces a customized set of high-level descriptions of the product features developed between your current and target releases. This tool is available here: