Oracle® Hyperion Smart View for Office

New Features


Copyright © 2004, 2013, Oracle and/or its affiliates. All rights reserved.

Authors: EPM Information Development Team

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:


Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Table of Contents:

Features Introduced in Release

Features Introduced in Earlier Releases

HTTP Access for Shared Connection XML File

Starting with the 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, 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.

Accessing Help Locally or from an Internal Web Server

After installing Smart View, the online help is retrieved from a URL hosted on the 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 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 Enhancements

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, 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.

  • Function validation

    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

    • Invalid selection

    • 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.

New VBA Function: HypUIConnect

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.

New Planning Extension

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.

Documentation Certified on Apple Mobile Devices

You can view the documentation for this Release 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.

Features Introduced in Earlier Releases

If you are upgrading from Release,,,, or, 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