Transcription

HYPERION SMART VIEW FOR OFFICERELEASE 9.3.1.2.0USER’S GUIDE

Smart View User’s Guide, 9.3.1.2.0Copyright 2004, 2008, Oracle and/or its affiliates. All rights reserved.Authors: Information Development TeamThe Programs (which include both the software and documentation) contain proprietary information; they are providedunder a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, andother intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, exceptto the extent required to obtain interoperability with other independently created software or as specified by law, isprohibited.The information contained in this document is subject to change without notice. If you find any problems in thedocumentation, please report them to us in writing. This document is not warranted to be error-free. Except as may beexpressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced ortransmitted in any form or by any means, electronic or mechanical, for any purpose.If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of theUnited States Government, the following notice is applicable:U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered toU.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to theapplicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication,disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subjectto the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additionalrights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500Oracle Parkway, Redwood City, CA 94065.The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerousapplications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measuresto ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for anydamages caused by such use of the Programs.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of theirrespective owners.The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle isnot responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated withthe use of such content. If you choose to purchase any products or services from a third party, the relationship is directlybetween you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b)fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warrantyobligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that youmay incur from dealing with any third party.

ContentsChapter 1. Introduction to Smart View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11Smart View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11Smart View Benefits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11Smart View Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12Toolbar Buttons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12Shortcut Menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14Login Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14Using Google Search with Smart View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14For Microsoft Office 2007 Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15Chapter 2. Features and Data Source Providers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19Ad Hoc Features and Supported Data Source Providers . . . . . . . . . . . . . . . . . . . . . . . . . . 19Query Designer Features and Supported Data Source Providers . . . . . . . . . . . . . . . . . . . . 21Dynamic Data Access Features and Supported Data Source Providers . . . . . . . . . . . . . . . 22Hyperion Visual Explorer Features and Supported Data Source Providers . . . . . . . . . . . . 23Data Form Features and Supported Data Source Providers . . . . . . . . . . . . . . . . . . . . . . . 23Function Features and Supported Data Source Providers . . . . . . . . . . . . . . . . . . . . . . . . . 24Reporting and Analysis Document Import Features and Supported Data SourceProviders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24Chapter 3. Installing and Enabling Smart View and Visual Explorer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27Installing Smart View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27Enabling and Disabling Smart View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27Smart View and Essbase Spreadsheet Add-in . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Information for Administrators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Smart View Files Installed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Running Silent Installations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29Checking for New Smart View Versions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29Backward Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30Uninstalling Smart View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30Chapter 4. Using Connection Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33Using Connection Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33Contentsiii

About Data Sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34About Connection Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34Adding a Data Source Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34Adding a Data Source Through Direct Connection . . . . . . . . . . . . . . . . . . . . . . . . . . 35Adding a Data Source Through Shared Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36Connecting to a Data Source . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37Associating a Data Source Connection to a Worksheet . . . . . . . . . . . . . . . . . . . . . . . . . . 38Editing a Data Source Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38Setting a Default Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39Deleting a Data Source Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40Disconnecting from a Data Source . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40Changing Passwords for Essbase . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41Checking for Active Connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41Resetting Connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41Using the Shortcut Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41Chapter 5. Working with Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43Working with Data Forms in Excel Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43Opening Data Forms in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45Navigating in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45Viewing Data Form Instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45Viewing Multiple Data Forms in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46Selecting Members for Financial Management and Hyperion Enterprise DataForms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46Selecting a Range of Cells . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48Saving Custom Formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48Searching for a Page in Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48Copying and Pasting Cells . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49Entering Percentage Values in Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49Entering Date Values in Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49Writing #Missing Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50Adding Cell Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50Viewing and Editing Cell Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51Submitting Cell Text in Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51Subtotaling Values in Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51Changing a Data Cell's Currency in Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52Submitting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52Working with Business Rules for Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53Launching Business Rules in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54Launching Business Rules From a Data Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54ivContents

Entering Runtime Prompts for Business Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55Executing the Calculate Data Form and Calculate Currencies Business Rules . . . . . . . 56Adjusting and Spreading Data Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57Adjusting Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57Spreading Data for Time Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58How Spreading Data Works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58Spreading Data with Cell Locking in Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62Examples of Spreading Data with Cell Locking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62Working With Supporting Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63Adding Supporting Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64Totaling When Supporting Detail Cells Are Blank . . . . . . . . . . . . . . . . . . . . . . . . . . . 65Working with Supporting Detail Hierarchy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66Viewing or Changing Supporting Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Synchronizing Supporting Detail with Essbase . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Working with Formulas in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68Working with Smart Lists in Planning Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69Chapter 6. Query Designer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Query Designer Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Query Designer Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Creating Queries from Default Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72Extracting Queries from Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73Editing Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74Filtering Members in Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74Filtering Data . . . . . .