Oracle® Hyperion Smart View for Office

Accessibility Guide

Release 11.1.2.5.000

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:

U.S. GOVERNMENT RIGHTS:

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:

Enabling Accessibility for Smart View

Smart View Keyboard Equivalents

Installing and Configuring Help Locally

This document describes the accessibility features of Oracle Hyperion Smart View for Office. For information regarding supported assistive technologies, refer to the Oracle Enterprise Performance Management System Installation Start Here.

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program web site at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Enabling Accessibility for Smart View

You do not need to enable accessibility specifically for Smart View; it is always in accessible mode. Smart View output is in the form of Excel spreadsheets, Word documents, and PowerPoint slides, which are accessible through Microsoft Office. For information about Excel, Word, or PowerPoint accessibility, refer to Microsoft Office product documentation.

Note:

If you are using JAWS® Screen Reading Software, Oracle recommends using the Internet Explorer browser.

Smart View Keyboard Equivalents

This section describes the keyboard equivalents for the following:

Smart View Ribbon Keyboard Equivalents
Office 2007 Data Provider Keyboard Equivalents
Office 2010 Data Provider Keyboard Equivalents
Office 2013 Data Provider Keyboard Equivalents
Smart View Panel Navigation
Smart Query Panel Navigation
Smart Query Ribbon Keyboard Equivalents

Note:

Keyboard equivalents for languages other than English may be different from those listed in these tables.

Keyboard equivalents for provider ribbons may vary if other Office add-ins or extensions are installed. For example, Y may become Y1 or Y2 if there are ribbons created by add-ins in addition to Smart View.

Smart View Ribbon Keyboard Equivalents

Table 1 shows the keyboard equivalents for the Smart View ribbon in Excel 2007, 2010, and 2013. Table 2 shows the keyboard equivalents for the Smart View ribbon in Word and PowerPoint 2007. Table 3 shows the keyboard equivalents for the Smart View ribbon in Word and PowerPoint 2010 and 2013.

Table 1. Smart View Ribbon Keyboard Equivalents for Excel

Keys	Action
Alt+S	Display Smart View ribbon
Alt+S+P	Panel
Alt+S+C+1	Connections (Office 2007)
Alt +S+Y+1	Connections (Office 2010, 2013)
Alt+S+C+T	Connections, Active Connections (Office 2007, 2010)
Alt+S+Y+1+T	Connections, Active Connections (Office 2013)
Alt+S+C+E	Connections, Reset to Default Connection (Office 2007, 2010)
Alt+S+Y+1+E	Connections, Reset to Default Connection (Office 2013)
Alt+S+C+O	Connections, Reporting and Analysis Document (Office 2007, 2010)
Alt+S+Y+1+O	Connections, Reporting and Analysis Document (Office 2013)
Alt+S+C+O+E	Connections, Reporting and Analysis Document, Edit (Office 2007, 2010)
Alt+S+Y+1+O+E	Connections, Reporting and Analysis Document, Edit (Office 2013)
Alt+S+C+O+C	Connections, Reporting and Analysis Document, Edit Connection (Office 2007, 2010)
Alt+S+Y+1+O+C	Connections, Reporting and Analysis Document, Edit Connection (Office 2013)
Alt+S+C+U	Connections, Recently Used (Office 2007, 2010)
Alt+S+Y+1+U	Connections, Recently Used (Office 2013)
Alt+S+E+N	Undo (Office 2007)
Alt+S+Y+2	Undo (Office 2010, 2013)
Alt+S+E+D	Redo (Office 2007)
Alt+S+Y+3	Redo (Office 2010, 2013)
Alt+S+E+C	Copy (Office 2007)
Alt+S+Y+4	Copy (Office 2010, 2013)
Alt+S+E+V	Paste (Office 2007)
Alt+S+Y+5	Paste (Office 2010, 2013)
Alt+S+U	Functions
Alt+S+U+M	Functions, Manage POV
Alt+S+U+B	Functions, Build Function
Alt+S+U+F	Functions, Fix Links
Alt+S+U+Z	Functions, Visualize
Alt+S+U+Z+E	Functions, Visualize, Excel
Alt+S+D+R+R	Refresh, Refresh (Excel 2007)
Alt+S+Y+6+R	Refresh, Refresh (Excel 2010)
Alt+S+Y+8+R	Refresh, Refresh (Excel 2013)
Alt+S+D+R+A	Refresh, Replace and Refresh (Excel 2007)
Alt+S+Y+6+A	Refresh, Replace and Refresh (Excel 2010)
Alt+S+Y+8+A	Refresh, Replace and Refresh (Excel 2013)
Alt+S+D+R+S	Refresh, Refresh All Worksheets (Excel 2007)
Alt+S+Y+6+S	Refresh, Refresh All Worksheets (Excel 2010)
Alt+S+Y+8+S	Refresh, Refresh All Worksheets (Excel 2013)
Alt+S+Y	Submit Data (Excel 2007)
Alt+S+Y+7	Submit Data (Excel 2010)
Alt+S+Y+9	Submit Data (Excel 2013)
Alt+S+S	Options
Alt+S+H	Help
Alt+S+H+C	Help, Contents
Alt+S+H+P	Help, Oracle user Productivity Kit
Alt+S+H+S	Help, Technical Support
Alt+S+H+E	Help, EPM Documentation
Alt+S+H+Z	Help, About
Alt+S+F	Sheet Info
Alt+S+R+M	More
Alt+S+R+M+G	More, Migrate Active Workbook (Financial Management)
Alt+S+R+M+B	More, Migrate Batch (Financial Management)
Alt+S+R+M+R	More, Migrate Active Workbook (Hyperion Enterprise)
Alt+S+R+M+E	More, Migrate Batch (Hyperion Enterprise)
Alt+S+R+M+I	More, Insert Connection List
Alt+S+R+M+P	More, Import Metadata

Table 2. Smart View Ribbon Keyboard Equivalents for Word and PowerPoint 2007

Keys	Action
Alt+S+2	Display Smart View ribbon
Alt+S+2+P	Panel
Alt+S+2+C	Connections
Alt+S+2+C+O	Connections, Reporting and Analysis Document
Alt+S+2+C+O+C	Connections, Reporting and Analysis Document, Create Template
Alt+S+2+C+O+R	Connections, Reporting and Analysis Document, Refresh Template
Alt+S+2+C+O+E	Connections, Reporting and Analysis Document, Edit
Alt+S+2+C+O+C	Connections, Reporting and Analysis Document, Edit Connection
Alt+S+2+C+U	Connections, Recently Used
Alt+S+2+E+C	Copy Data Point
Alt+S+2+E+V	Paste Data Point
Alt+S+2+E+M	Manage POV
Alt+S+2+D+R+R	Refresh, Refresh
Alt+S+2+D+R+A	Refresh, Replace and Refresh
Alt+S+2+D+R+S	Refresh, Refresh All Slides
Alt+S+2+D+E	Visualize in Excel
Alt+S+2+S	Options
Alt+S+2+H	Help
Alt+S+2+H+C	Help, Contents
Alt+S+2+H+P	Help, Oracle User Productivity Kit
Alt+S+2+H+S	Help, Technical Support
Alt+S+2+H+E	Help, EPM Documentation
Alt+S+2+H+Z	Help, About

Table 3. Smart View Ribbon Keyboard Equivalents for Word and PowerPoint 2010 and 2013

Keys	Action
Alt+Y+1	Display Smart View ribbon (Office 2010)
Alt+Y	Display Smart View ribbon (Office 2013)
Alt+Y+1+P	Panel
Alt+Y+1+C	Connections
Alt+Y+1+C+O	Connections, Reporting and Analysis Document
Alt+Y+1+C+O+C	Connections, Reporting and Analysis Document, Create Template
Alt+Y+1+C+O+R	Connections, Reporting and Analysis Document, Refresh Template
Alt+Y+1+C+O+E	Connections, Reporting and Analysis Document, Edit
Alt+Y+1+C+O+C	Connections, Reporting and Analysis Document, Edit Connection
Alt+Y+1+C+U	Connections, Recently Used
Alt+Y+1+Y+2	Copy
Alt+Y+1+Y+3	Paste Data Point
Alt+Y+1+Y+4	Manage POV
Alt+Y+1+Y+5+R	Refresh
Alt+Y+1+Y+5+A	Refresh, Replace and Refresh
Alt+Y+1+Y+5+S	Refresh, Replace All Slides (PowerPoint 2010, 2013)
Alt+Y+1+Y+6	Visualize in Excel
Alt+Y+1+S	Options
Alt+Y+1+H	Help
Alt+Y+1+H+C	Help, Contents
Alt+Y+1+H+P	Help, Oracle User Productivity Kit
Alt+Y+1+H+S	Help, Technical Support
Alt+Y+1+H+E	Help, EPM Documentation
Alt+Y+1+H+Z	Help, About

Office 2007 Data Provider Keyboard Equivalents

The tables in this section list ribbon items for Office 2007 as follows:

Table 4, Data Provider Ribbon Keyboard Equivalents for Excel 2007
Table 5, Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2007
Table 6, Oracle BI EE Ribbon Keyboard Equivalents for Office 2007 (assumes Oracle BI EE ribbon is Y1)

Exceptions are noted in parentheses.

Table 4. Data Provider Ribbon Keyboard Equivalents for Excel 2007

Keys	Action
Alt+Y+Y	Analyze (Planning only)
Alt+Y+D+R	Refresh
Alt+Y+D+R+R	Refresh, Refresh
Alt+Y+D+R+A	Refresh, Refresh All
Alt+Y+D+D	Drill-through
Alt+Y+A+M	Add Member
Alt+Y+D+B	Submit Data
Alt+Y+D+E	Cell Comments
Alt+Y+D+P	Supporting Detail (Planning only)
Alt+Y+D+T	Document Attachment (Planning only)
Alt+Y+D+L	Lock (Planning only)
Alt+Y+D+C	Calculate
Alt+Y+D+C+B	Calculate, Business Rules (Planning only)
Alt+Y+D+C+U	Calculate, Rules on Form (Planning only)
Alt+Y+D+C+D	Calculate, Calculate
Alt+Y+D+C+F	Calculate, Force Calculate (HFM and Enterprise only)
Alt+Y+D+C+T	Calculate, Translate (HFM and Enterprise only)
Alt+Y+D+C+R	Calculate, Force Translate (HFM and Enterprise only)
Alt+Y+D+O+2	Consolidate (HFM and Enterprise only)
Alt+Y+D+O+2+N	Consolidate, Consolidate (HFM and Enterprise only)
Alt+Y+D+O+2+S	Consolidate, Consolidate All (HFM and Enterprise only)
Alt+Y+D+O+2+L	Consolidate, Consolidate All With Data (HFM and Enterprise only)
Alt+Y+D+O+2+A	Consolidate, Calculate Contribution (HFM and Enterprise only)
Alt+Y+D+O+2+O	Consolidate, Force Calculate Contribution (HFM only)
Alt+S+W	View Comments
Alt+Y+D+U	Adjust
Alt+Y+D+U+J	Adjust, Adjust
Alt+Y+D+U+G	Adjust, Grid Spread (Planning only)
Alt+Y+D+U+A	Adjust, Mass Allocate (Planning only)
Alt+Y+D+D	Drill-through
Alt+Y+D+M	More (Planning only)
Alt+Y+D+M+J	More, Job Console (Planning only)
Alt+Y+D+M+M	More, Member Formula (Planning only)
Alt+Y+D+M+I	More, Instructions (Planning only)
Alt+Y+D+M+F	More, Offline (Planning only)
Alt+Y+D+M+F+T	More, Offline, Take Offline (Planning only)
Alt+Y+D+M+F+Y	More, Offline, Sync Back to Server (Planning only)
Alt+Y+D+M+F+R	More, Offline, Refresh Offline Definition (Planning only)
Alt+Y+W+P	Approvals (Planning only)
Alt+Y+W+V	Copy Version (Planning only)

Table 5. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2007

Keys	Action
Alt+Y+A+Z	Zoom In
Alt+Y+A+Z+N	Zoom In, Next Level
Alt+Y+A+Z+A	Zoom In, All Levels
Alt+Y+A+Z+B	Zoom In, Bottom Level
Alt+Y+A+Z+E	Zoom In, Same Level (Essbase only)
Alt+Y+A+Z+L	Zoom In, Sibling Level (Essbase only)
Alt+Y+A+Z+G	Zoom In, Same Generation (Essbase only)
Alt+Y+A+Z+F	Zoom In, Formulas (Essbase only)
Alt+Y+A+U	Zoom Out
Alt+Y+A+T	Pivot
Alt+Y+A+T+P	Pivot, Pivot
Alt+Y+A+T+T	Pivot Pivot to POV
Alt+Y+A+K	Keep Only
Alt+Y+A+O	Remove Only
Alt+Y+A+I	Member Selection
Alt+Y+A+Q	Query
Alt+Y+A+Q+Q	Query, Query Designer
Alt+Y+A+Q+R	Query, Run Report
Alt+Y+A+Q+E	Query, Execute MDX (Essbase only)
Alt+Y+A+Q+D	Query, Data Filter
Alt+Y+A+E	Member Information (Essbase only)
Alt+Y+A+P	Preserve Format (except Enterprise Ad Hoc)
Alt+Y+A+A	Change Alias (Essbase only)
Alt+Y+A+D	Data Perspective (Essbase only)
Alt+Y+A+S	Smart Slice (except Enterprise)
Alt+Y+A+C	Cascade (except Enterprise Ad Hoc)
Alt+Y+A+C+S	Cascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+A+C+N	Cascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+A+C+D	Cascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+D+R	Refresh
Alt+Y+D+R+R	Refresh, Refresh
Alt+Y+D+R+A	Refresh, Refresh All
Alt+Y+D+O	POV
Alt+Y+D+W	View Comments
Alt+Y+D+C	Calculate
Alt+Y+D+Z	Visualize (Essbase only)
Alt+Y+D+Z+E	Visualize, Visualize in Excel (Essbase only)
Alt+Y+D+D	Drill-through
Alt+Y+J	Linked Objects (Essbase only)
Alt+Y+D+U	Adjust
Alt+Y+D+B	Submit Data

Table 6. Oracle BI EE Ribbon Keyboard Equivalents for Office 2007 (assumes Oracle BI EE ribbon is Y1)

Key	Action
Alt+Y+Y+1	View Designer
Alt+Y+Y+2	Publish View
Alt+Y+Y+3	Refresh
Alt+Y+Y+4	Edit Prompts
Alt+Y+Y+5	Edit Page Prompts
Alt+Y+Y+6	Copy
Alt+Y+Y+7	Paste
Alt+Y+Y+8	Delete
Alt+Y+Y+9	Mask Data

Office 2010 Data Provider Keyboard Equivalents

The tables in this section list ribbon items for Office 2010 as follows:

Table 7, Data Provider Ribbon Keyboard Equivalents for Excel 2010
Table 8, Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2010 32-bit
Table 10, Oracle BI EE Ribbon Keyboard Equivalents for Office 2010 (assumes Oracle BI EE Ribbon is Y1)

Exceptions are noted in parentheses.

Table 7. Data Provider Ribbon Keyboard Equivalents for Excel 2010

Keys	Action
Alt+Y+1+Y+2	Analyze (Planning only)
Alt+Y+1+D+R	Refresh
Alt+Y+1+D+R+R	Refresh, Refresh
Alt+Y+1+D+R+A	Refresh, Refresh All
Alt+Y+1+D+D	Drill-through
Alt+Y+1+A+M	Add Member
Alt+Y+1+D+B	Submit Data
Alt+Y+1+D+A	Cell Actions
Alt+Y+1+D+E	Cell Actions, Comments
Alt+Y+1+D+P	Cell Actions, Supporting Detail (Planning only)
Alt+Y+1+D+T	Cell Actions, Attachment (Planning only)
Alt+Y+1+D+H	Cell Actions, History
Alt+Y+1+D+L	Lock (Planning only)
Alt+Y+1+D+C	Calculate
Alt+Y+1+D+C+B	Calculate, Business Rules (Planning only)
Alt+Y+1+D+C+U	Calculate, Rules on Form (Planning only)
Alt+Y+1+D+C+D	Calculate, Calculate
Alt+Y+1+D+C+F	Calculate, Force Calculate (HFM and Enterprise only)
Alt+Y+1+D+C+T	Calculate, Translate (HFM and Enterprise only)
Alt+Y+1+D+C+R	Calculate, Force Translate (HFM and Enterprise only)
Alt+Y+1+D+O+2	Consolidate (HFM and Enterprise only)
Alt+Y+1+D+O+2+N	Consolidate, Consolidate (HFM and Enterprise only)
Alt+Y+1+D+O+2+S	Consolidate, Consolidate All (HFM and Enterprise only)
Alt+Y+1+D+O+2+L	Consolidate, Consolidate All With Data (HFM and Enterprise only)
Alt+Y+1+D+O+2+A	Consolidate, Calculate Contribution (HFM and Enterprise only)
Alt+Y+1+D+O+2+O	Consolidate, Force Calculate Contribution (HFM only)
Alt+Y+1+W	View Comments
Alt+Y+1+D+U	Adjust
Alt+Y+1+D+U+J	Adjust, Adjust
Alt+Y+1+D+U+G	Adjust, Grid Spread (Planning only)
Alt+Y+1+D+U+A	Adjust, Mass Allocate (Planning only)
Alt+Y+1+D+D	Drill-through
Alt+Y+1+D+M	More (Planning only)
Alt+Y+1+D+M+J	More, Job Console (Planning only)
Alt+Y+1+D+M+M	More, Member Formula (Planning only)
Alt+Y+1+D+M+I	More, Instructions (Planning only)
Alt+Y+1+D+M+F	More, Offline (Planning only)
Alt+Y+1+D+M+F+T	More, Offline, Take Offline (Planning only)
Alt+Y+1+D+M+F+Y	More, Offline, Sync Back to Server (Planning only)
Alt+Y+1+D+M+F+R	More, Offline, Refresh Offline Definition (Planning only)
Alt+Y+1+Y+4	Approvals (Planning only)
Alt+Y+1+Y+5	Copy Version (Planning only)

Table 8. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2010 32-bit

Keys	Action
Alt+Y+1+Y+2	Zoom In
Alt+Y+1+Y+2+N	Zoom In, Next Level
Alt+Y+1+Y+2+A	Zoom In, All Levels
Alt+Y+1+Y+2+B	Zoom In, Bottom Level
Alt+Y+1+Y+2+E	Zoom In, Same Level (Essbase only)
Alt+Y+1+Y+2+L	Zoom In, Sibling Level (Essbase only)
Alt+Y+1+Y+2+G	Zoom In, Same Generation (Essbase only)
Alt+Y+1+Y+2+F	Zoom In, Formulas (Essbase only)
Alt+Y+1+Y+3	Zoom Out
Alt+Y+1+Y+4	Pivot
Alt+Y+1+Y+4+P	Pivot, Pivot
Alt+Y+1+Y+4+T	Pivot Pivot to POV
Alt+Y+1+Y+5	Keep Only
Alt+Y+1+Y+6	Remove Only
Alt+Y+1+Y+7	Member Selection
Alt+Y+1+Y+8	Query
Alt+Y+1+Y+8+Q	Query, Query Designer
Alt+Y+1+Y+8+R	Query, Run Report
Alt+Y+1+Y+8+E	Query, Execute MDX (Essbase only)
Alt+Y+1+Y+8+D	Query, Data Filter
Alt+Y+1+Y+9	Member Information (Essbase only)
Alt+Y+1+Y+A	Preserve Format (except Enterprise Ad Hoc)
Alt+Y+1+Y+B	Change Alias (Essbase only) (32-bit)
Alt+Y+1+Y+C	Data Perspective (Essbase only)
Alt+Y+1+Y+D	Smart Slice (except Enterprise)
Alt+Y+1+Y+E	Cascade (except Enterprise Ad Hoc)
Alt+Y+1+Y+E+S	Cascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+E+N	Cascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+E+D	Cascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+1+D+R	Refresh
Alt+Y+1+D+R+R	Refresh, Refresh
Alt+Y+1+D+R+A	Refresh, Refresh All
Alt+Y+1+D+O	POV
Alt+Y+1+D+W	View Comments
Alt+Y+1+D+C	Calculate
Alt+Y+1+D+Z	Visualize (Essbase only)
Alt+Y+1+D+Z+E	Visualize, Visualize in Excel (Essbase only)
Alt+Y+1+D+D	Drill-through
Alt+Y+1+J	Linked Objects (Essbase only)
Alt+Y+1+D+U	Adjust
Alt+Y+1+D+B	Submit Data

Table 9. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2010 64-bit

Keys	Action
Alt+Y+1+Y+5	Zoom In
Alt+Y+1+Y+5+N	Zoom In, Next Level
Alt+Y+1+Y+5+A	Zoom In, All Levels
Alt+Y+1+Y+5+B	Zoom In, Bottom Level
Alt+Y+1+Y+5+E	Zoom In, Same Level (Essbase only)
Alt+Y+1+Y+5+L	Zoom In, Sibling Level (Essbase only)
Alt+Y+1+Y+5+G	Zoom In, Same Generation (Essbase only)
Alt+Y+1+Y+5+F	Zoom In, Formulas (Essbase only)
Alt+Y+1+Y+6	Zoom Out
Alt+Y+1+Y+7	Pivot
Alt+Y+1+Y+7+P	Pivot, Pivot
Alt+Y+1+Y+7+T	Pivot Pivot to POV
Alt+Y+1+Y+8	Keep Only
Alt+Y+1+Y+9	Remove Only
Alt+Y+1+Y+B	Member Selection
Alt+Y+1+Y+B	Query
Alt+Y+1+Y+B+Q	Query, Query Designer
Alt+Y+1+Y+B+R	Query, Run Report
Alt+Y+1+Y+B+E	Query, Execute MDX (Essbase only)
Alt+Y+1+Y+B+D	Query, Data Filter
Alt+Y+1+Y+C	Member Information (Essbase only)
Alt+Y+1+Y+D	Preserve Format (except Enterprise Ad Hoc)
Alt+Y+1+Y+E	Change Alias (Essbase only)
Alt+Y+1+Y+F	Data Perspective (Essbase only)
Alt+Y+1+Y+G	Smart Slice (except Enterprise)
Alt+Y+1+Y+H	Cascade (except Enterprise Ad Hoc)
Alt+Y+1+Y+H+S	Cascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+H+N	Cascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+H+D	Cascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+1+D+R	Refresh
Alt+Y+1+D+R+R	Refresh, Refresh
Alt+Y+1+D+R+A	Refresh, Refresh All
Alt+Y+1+D+O	POV
Alt+Y+1+D+W	View Comments
Alt+Y+1+D+C	Calculate
Alt+Y+1+D+Z	Visualize (Essbase only)
Alt+Y+1+D+Z+E	Visualize, Visualize in Excel (Essbase only)
Alt+Y+1+D+D	Drill-through
Alt+Y+1+J	Linked Objects (Essbase only)
Alt+Y+1+D+U	Adjust
Alt+Y+1+D+B	Submit Data

Table 10. Oracle BI EE Ribbon Keyboard Equivalents for Office 2010 (assumes Oracle BI EE Ribbon is Y1)

Key	Action
Alt+Y+1+Y+2	View Designer
Alt+Y+1+Y+3	Publish View
Alt+Y+1+Y+4	Refresh
Alt+Y+1+Y+5	Edit Prompts
Alt+Y+1+Y+6	Edit Page Prompts
Alt+Y+1+Y+7	Copy
Alt+Y+1+Y+8	Paste
Alt+Y+1+Y+9	Delete
Alt+Y+1+Y+A	Mask Data

Office 2013 Data Provider Keyboard Equivalents

The tables in this section list ribbon items for Office 2013 as follows:

Table 11, Data Provider Ribbon Keyboard Equivalents for Excel 2013
Table 12, Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2013
Table 13, Oracle BI EE Ribbon Keyboard Equivalents for Office 2013 (assumes Oracle BI EE Ribbon is Y1)

Exceptions are noted in parentheses.

Table 11. Data Provider Ribbon Keyboard Equivalents for Excel 2013

Keys	Action
Alt+Y+1+Y+2	Analyze (Planning only)
Alt+Y+1+D+R	Refresh
Alt+Y+1+D+R+R	Refresh, Refresh
Alt+Y+1+D+R+S	Refresh, Refresh All Worksheets
Alt+Y+1+D+D	Drill-through
Alt+Y+1+A+M	Add Member
Alt+Y+1+D+B	Submit Data
Alt+Y+1+D+A	Cell Actions
Alt+Y+1+D+E	Cell Actions, Comments
Alt+Y+1+D+P	Cell Actions, Supporting Detail (Planning only)
Alt+Y+1+D+T	Cell Actions, Attachment (Planning only)
Alt+Y+1+D+H	Cell Actions, History
Alt+Y+1+D+L	Lock (Planning only)
Alt+Y+1+D+C	Calculate
Alt+Y+1+D+C+B	Calculate, Business Rules (Planning only)
Alt+Y+1+D+C+U	Calculate, Rules on Form (Planning only)
Alt+Y+D+C+C	Calculate, Calculate (HFM and Enterprise only)
Alt+Y+D+C+F	Calculate, Force Calculate (HFM and Enterprise only)
Alt+Y+1+D+C+T	Calculate, Translate (HFM and Enterprise only)
Alt+Y+1+D+C+R	Calculate, Force Translate (HFM and Enterprise only)
Alt+Y+1+Y+C	Consolidate (HFM and Enterprise only)
Alt+Y+1+Y+C+N	Consolidate, Consolidate (HFM and Enterprise only)
Alt+Y+1+Y+C+S	Consolidate, Consolidate All (HFM and Enterprise only)
Alt+Y+1+Y+C+L	Consolidate, Consolidate All With Data (HFM and Enterprise only)
Alt+Y+1+Y+C+A	Consolidate, Calculate Contribution (HFM and Enterprise only)
Alt+Y+1+Y+C+O	Consolidate, Force Calculate Contribution (HFM only)
Alt+Y+1+D+E	Cell Comments
Alt+Y+1+D+U	Adjust
Alt+Y+1+D+U+J	Adjust, Adjust
Alt+Y+1+D+U+G	Adjust, Grid Spread (Planning only)
Alt+Y+1+D+U+A	Adjust, Mass Allocate (Planning only)
Alt+Y+1+D+D	Drill-through
Alt+Y+1+D+M	More (Planning only)
Alt+Y+1+D+M+J	More, Job Console (Planning only)
Alt+Y+1+D+M+M	More, Member Formula (Planning only)
Alt+Y+1+D+M+I	More, Instructions (Planning only)
Alt+Y+1+D+M+F	More, Offline (Planning only)
Alt+Y+1+D+M+F+T	More, Offline, Take Offline (Planning only)
Alt+Y+1+D+M+F+Y	More, Offline, Sync Back to Server (Planning only)
Alt+Y+1+D+M+F+R	More, Offline, Refresh Offline Definition (Planning only)
Alt+Y+1+Y+3	Approvals (Planning only)
Alt+Y+1+Y+4	Copy Version (Planning only)

Table 12. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2013

Keys	Action
Alt+Y+1+Y+2	Zoom In
Alt+Y+1+Y+2+N	Zoom In, Next Level
Alt+Y+1+Y+2+A	Zoom In, All Levels
Alt+Y+1+Y+2+B	Zoom In, Bottom Level
Alt+Y+1+Y+2+E	Zoom In, Same Level (Essbase only)
Alt+Y+1+Y+2+L	Zoom In, Sibling Level (Essbase only)
Alt+Y+1+Y+2+G	Zoom In, Same Generation (Essbase only)
Alt+Y+1+Y+2+F	Zoom In, Formulas (Essbase only)
Alt+Y+1+Y+3	Zoom Out
Alt+Y+1+Y+4	Pivot
Alt+Y+1+Y+4+P	Pivot, Pivot
Alt+Y+1+Y+4+T	Pivot Pivot to POV
Alt+Y+1+Y+5	Keep Only
Alt+Y+1+Y+6	Remove Only
Alt+Y+1+Y+7	Member Selection
Alt+Y+1+Y+8	Query
Alt+Y+1+Y+8+Q	Query, Query Designer
Alt+Y+1+Y+8+R	Query, Run Report
Alt+Y+1+Y+8+E	Query, Execute MDX (Essbase only)
Alt+Y+1+Y+8+D	Query, Data Filter
Alt+Y+1+A+E	Member Information (Essbase only)
Alt+Y+1+Y+9	Preserve Format (except Enterprise Ad Hoc)
Alt+Y+1+Y+A	Change Alias (Essbase only)
Alt+Y+1+A+D	Data Perspective (Essbase only)
Alt+Y+1+Y+B	Smart Slice (except Enterprise)
Alt+Y+1+Y+C	Cascade (except Enterprise Ad Hoc)
Alt+Y+1+Y+C+S	Cascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+C+N	Cascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+C+D	Cascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+1+D+R	Refresh
Alt+Y+1+D+R+R	Refresh, Refresh
Alt+Y+1+D+R+A	Refresh, Refresh All
Alt+Y+1+Y+D	POV
Alt+Y+1+D+W	View Comments
Alt+Y+1+D+C	Calculate
Alt+Y+1+D+Z	Visualize (Essbase only)
Alt+Y+1+D+Z+E	Visualize, Visualize in Excel (Essbase only)
Alt+Y+1+D+D	Drill-through
Alt+Y+1+J	Linked Objects (Essbase only)
Alt+Y+1+D+U	Adjust
Alt+Y+1+D+B	Submit Data

Table 13. Oracle BI EE Ribbon Keyboard Equivalents for Office 2013 (assumes Oracle BI EE Ribbon is Y1)

Key	Action
Alt+Y+1+Y+3	View Designer
Alt+Y+1+Y+4	Publish View
Alt+Y+1+Y+5	Refresh
Alt+Y+1+Y+6	Edit Prompts
Alt+Y+1+Y+7	Edit Page Prompts
Alt+Y+1+Y+8	Copy
Alt+Y+1+Y+9	Paste
Alt+Y+1+Y+A	Delete
Alt+Y+1+Y+B	Mask Data

Smart View Panel Navigation

Table 14 displays the keys for navigating in the Smart View Panel.

Table 14. Smart View Panel Navigation

Keys	Action
Alt+S+P	Launch the Smart View Panel (Office 2007 and 2010)
F6	Switch between Smart View and Office components
Tab	Scroll through Smart View Panel
Up and down arrow keys	Scroll through items in tree view
Left and right arrow keys	In toolbars, move through buttons In tree views, expand or collapse a node
Alt+tab	Move from tree view to Action Panel
Alt+down arrow	Open the drop-down menu
Up and down arrow keys	Scroll through drop-down list
Enter	Select an item in the drop-down menu
Escape	Cancel selection

Smart Query Panel Navigation

Table 15. Smart Query Panel Navigation

Keys	Action
F6	Switch between Smart Query and Office components
Ctl+Enter	Set focus from a dimension down to its properties
Ctl+X and Ctl+V	Move dimensions between axes

Smart Query Ribbon Keyboard Equivalents

The tables in this section list ribbon items for the Smart Query ribbon as follows:

Table 16, Smart Query Ribbon Keyboard Equivalents for Office 2007
Table 17, Smart Query Ribbon Keyboard Equivalents for Office 2010
Table 18, Smart Query Ribbon Keyboard Equivalents for Office 2013

Exceptions are noted in parentheses.

Table 16. Smart Query Ribbon Keyboard Equivalents for Office 2007

Key	Action
Alt+Y+Y+0+1	Analyze
Alt+Y+Y+0+2	Designer Panel
Alt+Y+Y+0+3	Copy
Alt+Y+Y+0+4	Paste
Alt+Y+Y+0+5	Save
Alt+Y+Y+0+6	Open
Alt+Y+Y+0+7	Refresh
Alt+Y+Y+0+8	Automatic Refresh
Alt+Y+Y+0+9	Change Alias
Alt+Y+1+Y+B, Down arrow key once + Enter	Change Alias, None
Alt+Y+1+Y+B, Down arrow key twice + Enter	Change Alias, More Alias Tables
Alt+Y+Y+1+0	Indentation
Alt+Y+Y+1+1	Show Distinct Member Names
Alt+Y+Y+1+2	Suppress Rows with No Data

Table 17. Smart Query Ribbon Keyboard Equivalents for Office 2010

Key	Action
Alt+Y+1+Y+3	Analyze
Alt+Y+1+Y+4	Designer Panel
Alt+Y+1+Y+5	Copy
Alt+Y+1+Y+6	Paste
Alt+Y+1+Y+7	Save
Alt+Y+1+Y+8	Open
Alt+Y+1+Y+9	Refresh
Alt+Y+1+Y+A	Automatic Refresh
Alt+Y+1+Y+B	Change Alias
Alt+Y+1+Y+B, Down arrow key once + Enter	Change Alias, None
Alt+Y+1+Y+B, Down arrow key twice + Enter	Change Alias, More Alias Tables
Alt+Y+1+Y+C	Indentation
Alt+Y+1+Y+D	Show Distinct Member Names
Alt+Y+1+Y+E	Suppress Rows with No Data

Table 18. Smart Query Ribbon Keyboard Equivalents for Office 2013

Key	Action
Alt+Y+1+Y+2	Analyze
Alt+Y+1+Y+3	Designer Panel
Alt+Y+1+Y+4	Copy
Alt+Y+1+Y+5	Paste
Alt+Y+1+Y+6	Save
Alt+Y+1+Y+7	Open
Alt+Y+1+Y+8	Refresh
Alt+Y+1+Y+A	Automatic Refresh
Alt+Y+1+Y+B	Change Alias
Alt+Y+1+Y+B, Down arrow key once + Enter	Change Alias, None
Alt+Y+1+Y+B, Down arrow key twice + Enter	Change Alias, More Alias Tables
Alt+Y+1+Y+C	Indentation
Alt+Y+1+Y+D	Show Distinct Member Names
Alt+Y+1+Y+E	Suppress Rows with No Data

Installing and Configuring Help Locally

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 for Section 508 accessibility purposes. To accommodate this, help must be downloaded from My Oracle Support and placed on a local drive or web server, and the Smart View properties.xml file must be modified.

To install and configure Smart View help locally:

Obtain the patch zip file for this release from My Oracle Support.

Extract the contents of the patch zip file to a local folder on the computer where Smart View is installed.

For example, extract the contents locally to:

C:\Oracle\SmartView\

Under the smartview_help folder, there are 28 language folders; for example:

C:\Oracle\SmartView
               \smartview_help
                    \ar
                    \cs
                    \da
                    \de
                    \el
                    \en
                    \es
                    \fi
                    \fr
                    \fr_CA
                    \he
                    \hu
                    \it
                    \ja
                    \ko
                    \nl
                    \no
                    \pl
                    \pt
                    \pt_BR
                    \ro
                    \ru
                    \sk
                    \sv
                    \th
                    \tr
                    \zh_CN
                    \zh_TW

The following language folders contain translated versions of the Smart View help:

The remaining language folders contain the English version of the help. When you run Smart View in one of those languages (for example, Swedish) and you click a button for Help, the English help is displayed.

Additionally, the English folder contains a copy of the help in PDF format, smartview_user.pdf.

Modify the helpurlcontext property in the Smart View properties.xml file:
1. In your Smart View installation, navigate to the SmartView\cfg folder.
2. Make a backup copy of the original properties.xml file.
3. Open properties.xml for editing.
4. Modify the helpurlcontext property, providing the path to the folder that is parent to the language folders, providing the path to the folder that is parent to the language folders using the following syntax:
```
<helpurlcontext>file:///parent_language_folder_path/</helpurlcontext>
```
  Tip:
  Use forward slashes in the syntax and ensure that you enter a final forward slash (/) after the parent language folder path that you provide.
  Using the example from step 2, after extracting the zip contents to C:\Oracle\SmartView, the smartview_help folder is the parent folder of the language folders. Thus, you would modify the parent_language_folder_path placeholder as follows:
```
<helpurlcontext>file:///C:/Oracle/SmartView/smartview_help/</helpurlcontext>
```
Restart your Microsoft Office applications and access the help from the Smart View ribbon.
Repeat this procedure for each computer that requires Oracle Hyperion Smart View for Office local help.