Table of Contents:
Starting with the 184.108.40.206.310 release, when connecting to Oracle Hyperion Smart View for Office data sources, shared connection information could be added to an XML file, stored on a user's local drive, and used to connect to shared providers. In Release 220.127.116.11, the shared connection XML file can now be stored on a web server and accessed by all users that you, as the Smart View administrator, designate.
Storing the shared connection XML file on an HTTP server simplifies the Smart View administrator's task of providing shared connection URL information to users.
In this release, the shared connection XML file method is the only way to connect to Oracle Business Intelligence Enterprise Edition providers using a shared connection; however, Oracle Business Intelligence Enterprise Edition connections can also be made using private connections. This feature now gives administrators the option of storing the XML file on each user's local machine or on an HTTP server and granting access to users.
Users point to the XML file location on the HTTP server in the Shared Connections URL field of the Options dialog box. They can then access the available connections as they would any other shared connection to which they have access.
For instructions on setting up the shared connections XML file on an HTTP server, see “Accessing Shared Connections from an XML File” in the Oracle Hyperion Smart View for Office User's Guide.
After installing Smart View, the online help is retrieved from a URL hosted on the Oracle.com web site. This is the default behavior for Smart View and no changes are required by users to launch help.
However, you may require that the help be installed locally or on a web server in your organization. Some examples for the need to access help from a location other than Oracle.com are:
Help files must be installed on a local drive on an individual's computer for Section 508 accessibility purposes.
Internet access limitations; for example, your users only have access to URLs on your organization's intranet.
To accommodate the above types of cases, you may download from My Oracle Support and place it on a local drive or web server.
See “Installing and Configuring Help Locally or on a Web Server” in the Oracle Hyperion Smart View for Office User's Guide for more information.
Function Builder usability is improved with two new enhancements in this release:
Cell references to two cells
Prior to this release, you could enter references to single cells for connection, label, data/text, or variable arguments. Starting with Release 18.104.22.168, you can also enter references to two contiguous or noncontiguous cells for dimension/member references. References cannot be made to cell ranges of more than two cells.
See “Using Cell References,” a subsection of “Creating Functions in the Function Builder” in the “Functions” chapter of the Oracle Hyperion Smart View for Office User's Guide.
A new Validate button in the Function Arguments dialog box allows you to see and correct errors immediately, before executing a function. The types of errors that may be noted are:
Connection offline or invalid
Member name is invalid or not matching selected alias
Dimension name is invalid or not matching selected alias
Incomplete Dimension#Member combination
Generic “Error” in cases of missing quotation marks or other minor syntax errors
Because you can see and correct errors on-the-fly, the validation feature saves you time in troubleshooting any problems in your function.
See step 6 in “Creating Functions in the Function Builder” in the “Functions” chapter of the Oracle Hyperion Smart View for Office User's Guide.
A new VBA function is introduced in this release: HypUIConnect(). HypUIConnect prompts the user with the Connect to Data Source dialog box when the user name and password is not provided. It does not prompt if already connected.
For more information on this function, see “HypUIConnect” in the Oracle Hyperion Smart View for Office Developer's Guide.
The new Hyperion Planning Admin Extension for Smart View allows Oracle Hyperion Planning administrator users to import and work with metadata in Smart View. With this extension, Planning administrators can use Oracle Hyperion Smart View for Office applications to perform these tasks:
Add, edit and import existing Oracle Hyperion Planning dimensions and members, including moving members and designating members as shared in Smart View
Create and refresh cubes
See “Using Smart View to Import and Edit Planning Metadata” in the Oracle Hyperion Planning Administrator's Guide for more information on using this extension.
You can view the documentation for this Release 22.214.171.124 using .mobi and .ePub files. This enables you to view documentation files on Apple devices such as iPads, iPhones, and iPod Touches). Additional devices will be certified for EPM documentation support over time.
If you are upgrading from Release 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11.300, or 18.104.22.168.310, use the Cumulative Feature Overview (CFO) tool to review the list of new features added between those releases. The CFO tool enables you to identify your current products, your current release version, and your target implementation release version. It also enables you to quickly produce a customized set of high-level descriptions of the product features developed between your current release and your target release, enabling you to get an overview of the functionality available. The CFO tool is available at https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1092114.1