Oracle® Hyperion Smart View for Office

Accessibility Guide

Release 11.1.2.2.310

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:

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

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, we recommend using the Internet Explorer browser.

Smart View Keyboard Equivalents

This section describes the keyboard equivalents for the following:

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 Oracle Hyperion Smart View for Office.

Smart View Ribbon Keyboard Equivalents

Table 1 shows the keyboard equivalents for the Smart View ribbon in Excel 2007 and 2010. 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.

Table 1. Smart View Ribbon Keyboard Equivalents for Excel

KeysAction
Alt+SDisplay Smart View ribbon
Alt+S+PPanel
Alt+S+CConnections
Alt+S+C+TConnections, Active Connections
Alt+S+C+EConnections, Reset to Default Connection
Alt+S+C+OConnections, Reporting and Analysis Document
Alt+S+C+O+EConnections, Reporting and Analysis Document, Edit
Alt+S+C+UConnections, Recently Used
Alt+S+E+NUndo (Office 2007)
Alt+S+Y+2 Undo (Office 2010)
Alt+S+E+DRedo (Office 2007)
Alt+S+Y+3Redo (Office 2010)
Alt+S+E+CCopy Data Point (Office 2007)
Alt+S+Y+4Copy Data Point (Office 2010)
Alt+S+E+VPaste Data Point (Office 2007)
Alt+S+Y+5Paste Data Point (Office 2010)
Alt+S+UFunctions
Alt+S+U+MFunctions, Manage POV
Alt+S+U+BFunctions, Build Function
Alt+S+U+ZFunctions, Visualize
Alt+S+U+Z+EFunctions, Visualize, Excel
Alt+S+D+RRefresh (Office 2007)
Alt+S+Y+6Refresh (Office 2010)
Alt+S+D+R+RRefresh, Refresh (Office 2007)
Alt+S+Y+6+RRefresh, Refresh (Office 2010)
Alt+S+D+R+SRefresh, Refresh All Worksheets
Alt+S+Y+6+SRefresh, Refresh All Worksheets (Office 2010)
Alt+S+YSubmit Data (Office 2007)
Alt+S+Y+7Submit Data (Office 2010)
Alt+S+SOptions
Alt+S+HHelp
Alt+S+H+CHelp, Contents
Alt+S+H+PHelp, Oracle user Productivity Kit
Alt+S+H+SHelp, Technical Support
Alt+S+H+EHelp, EPM Documentation
Alt+S+H+ZHelp, About
Alt+S+FSheet Info
Alt+S+R+MMore
Alt+S+R+M+GMore, Migrate Active Workbook (Financial Management)
Alt+S+R+M+BMore, Migrate Batch (Financial Management)
Alt+S+R+M+RMore, Migrate Active Workbook (Hyperion Enterprise)
Alt+S+R+M+EMore, Migrate Batch (Hyperion Enterprise)
Alt+S+R+M+IMore, Insert Connection List
Alt+S+R+M+PMore, Import Metadata

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

KeysAction
Alt+S+2Display Smart View ribbon
Alt+S+2+PPanel
Alt+S+2+CConnections
Alt+S+2+C+OConnections, Reporting and Analysis Document
Alt+S+2+C+O+CConnections, Reporting and Analysis Document, Create Template
Alt+S+2+C+O+RConnections, Reporting and Analysis Document, Refresh Template
Alt+S+2+C+UConnections, Recently Used
Alt+S+2+E+CCopy Data Point
Alt+S+2+E+VPaste Data Point
Alt+S+2+E+MManage POV
Alt+S+2+RRefresh
Alt+S+2+D+EVisualize in Excel
Alt+S+2+SOptions
Alt+S+2+HHelp
Alt+S+2+H+CHelp, Contents
Alt+S+2+H+PHelp, Oracle User Productivity Kit
Alt+S+2+H+SHelp, Technical Support
Alt+S+2+H+EHelp, EPM Documentation
Alt+S+2+H+ZHelp, About

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

KeysAction
Alt+Y+1+SDisplay Smart View ribbon
Alt+Y+1+PPanel
Alt+Y+1+CConnections
Alt+Y+1+C+OConnections, Reporting and Analysis Document
Alt+Y+1+C+O+CConnections, Reporting and Analysis Document, Create Template
Alt+Y+1+C+O+RConnections, Reporting and Analysis Document, Refresh Template
Alt+Y+1+C+UConnections, Recently Used
Alt+Y+1+Y+2Copy Data Point
Alt+Y+1+Y+3Paste Data Point
Alt+Y+1+Y+4Manage POV
Alt+Y+1+RRefresh
Alt+Y+1+Y+5Visualize in Excel
Alt+Y+1+SOptions
Alt+Y+1+HHelp
Alt+Y+1+H+CHelp, Contents
Alt+Y+1+H+PHelp, Oracle User Productivity Kit
Alt+Y+1+H+SHelp, Technical Support
Alt+Y+1+H+EHelp, EPM Documentation
Alt+Y+1+H+ZHelp, About

Office 2010 Data Provider Keyboard Equivalents

Table 4 lists the keyboard equivalents on data provider ribbons for Office 2010. Table 5 lists the keyboard equivalents for items on the Essbase, Planning Ad Hoc, HFM Ad Hoc, Enterprise Ad Hoc ribbons in Excel 2010. Exceptions are noted in parentheses.

Table 4. Data Provider Ribbon Keyboard Equivalents for Excel 2007

KeysAction
Alt+Y+1+Y+3Analyze (Planning only)
Alt+Y+1+D+RRefresh
Alt+Y+1+D+R+R Refresh, Refresh
Alt+Y+1+D+R+ARefresh, Refresh All
Alt+Y+1+D+DDrill-through
Alt+Y+1+A+MAdd Member
Alt+Y+1+D+BSubmit Data
Alt+Y+1+D+ACell Actions
Alt+Y+1+D+ECell Actions, Comments
Alt+Y+1+D+PCell Actions, Supporting Detail (Planning only)
Alt+Y+1+D+TCell Actions, Attachment (Planning only)
Alt+Y+1+D+HCell Actions, History
Alt+Y+1+D+LLock (Planning only)
Alt+Y+1+D+CCalculate
Alt+Y+1+D+C+BCalculate, Business Rules (Planning only)
Alt+Y+1+D+C+UCalculate, Rules on Form (Planning only)
Alt+Y+1+D+C+DCalculate, Calculate
Alt+Y+1+D+C+FCalculate, Force Calculate (HFM and Enterprise only)
Alt+Y+1+D+C+TCalculate, Translate (HFM and Enterprise only)
Alt+Y+1+D+C+RCalculate, Force Translate (HFM and Enterprise only)
Alt+Y+1+D+O+2Consolidate (HFM and Enterprise only)
Alt+Y+1+D+O+2+NConsolidate, Consolidate (HFM and Enterprise only)
Alt+Y+1+D+O+2+SConsolidate, Consolidate All (HFM and Enterprise only)
Alt+Y+1+D+O+2+LConsolidate, Consolidate All With Data (HFM and Enterprise only)
Alt+Y+1+D+O+2+AConsolidate, Calculate Contribution (HFM and Enterprise only)
Alt+Y+1+D+O+2+OConsolidate, Force Calculate Contribution (HFM only)
Alt+Y+1+WView Comments
Alt+Y+1+D+UAdjust
Alt+Y+1+D+U+JAdjust, Adjust
Alt+Y+1+D+U+GAdjust, Grid Spread (Planning only)
Alt+Y+1+D+U+AAdjust, Mass Allocate (Planning only)
Alt+Y+1+D+DDrill-through
Alt+Y+1+D+MMore (Planning only)
Alt+Y+1+D+M+JMore, Job Console (Planning only)
Alt+Y+1+D+M+MMore, Member Formula (Planning only)
Alt+Y+1+D+M+IMore, Instructions (Planning only)
Alt+Y+1+D+M+FMore, Offline (Planning only)
Alt+Y+1+D+M+F+TMore, Offline, Take Offline (Planning only)
Alt+Y+1+D+M+F+YMore, Offline, Sync Back to Server (Planning only)
Alt+Y+1+D+M+F+RMore, Offline, Refresh Offline Definition (Planning only)
Alt+Y+1+Y+4Approvals (Planning only)
Alt+Y+1+Y+5Copy Version (Planning only)

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

KeysAction
Alt+Y+1+Y+3Zoom In
Alt+Y+1+Y+3+NZoom In, Next Level
Alt+Y+1+Y+3+AZoom In, All Levels
Alt+Y+1+Y+3+BZoom In, Bottom Level
Alt+Y+1+Y+3+EZoom In, Same Level (Essbase only)
Alt+Y+1+Y+3+LZoom In, Sibling Level (Essbase only)
Alt+Y+1+Y+3+GZoom In, Same Generation (Essbase only)
Alt+Y+1+Y+3+FZoom In, Formulas (Essbase only)
Alt+Y+1+Y+4Zoom Out
Alt+Y+1+Y+5Pivot
Alt+Y+1+Y+5+PPivot, Pivot
Alt+Y+1+Y+5+TPivot Pivot to POV
Alt+Y+1+Y+6Keep Only
Alt+Y+1+Y+7Remove Only
Alt+Y+1+Y+8Member Selection
Alt+Y+1+Y+9Query
Alt+Y+1+Y+9+QQuery, Query Designer
Alt+Y+1+Y+9+RQuery, Run Report
Alt+Y+1+Y+9+EQuery, Execute MDX (Essbase only)
Alt+Y+1+Y+9+DQuery, Data Filter
Alt+Y+1+Y+AMember Information (Essbase only)
Alt+Y+1+Y+BPreserve Format (except Enterprise Ad Hoc)
Alt+Y+1+Y+CChange Alias (Essbase only)
Alt+Y+1+Y+DData Perspective (Essbase only)
Alt+Y+1+Y+ESmart Slice (except Enterprise)
Alt+Y+1+Y+FCascade (except Enterprise Ad Hoc)
Alt+Y+1+Y+F+SCascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+F+NCascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+F+DCascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+1+D+RRefresh
Alt+Y+1+D+R+R Refresh, Refresh
Alt+Y+1+D+R+ARefresh, Refresh All
Alt+Y+1+D+OPOV
Alt+Y+1+D+WView Comments
Alt+Y+1+D+CCalculate
Alt+Y+1+D+ZVisualize (Essbase only)
Alt+Y+1+D+Z+EVisualize, Visualize in Excel (Essbase only)
Alt+Y+1+D+DDrill-through
Alt+Y+1+JLinked Objects (Essbase only)
Alt+Y+1+D+UAdjust
Alt+Y+1+D+BSubmit Data

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

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

Office 2007 Data Provider Keyboard Equivalents

Table 7 lists the keyboard equivalents on data provider ribbons for Office 2007. Table 8 lists the keyboard equivalents for items only on the Essbase, Planning Ad Hoc, HFM Ad Hoc, and Enterprise Ad Hoc ribbons for Office 2007. Exceptions are noted in parentheses.

Table 7. Data Provider Ribbon Keyboard Equivalents for Excel 2007

KeysAction
Alt+Y+YAnalyze (Planning only)
Alt+Y+D+RRefresh
Alt+Y+D+R+R Refresh, Refresh
Alt+Y+D+R+ARefresh, Refresh All
Alt+Y+D+DDrill-through
Alt+Y+A+MAdd Member
Alt+Y+D+BSubmit Data
Alt+Y+D+ECell Comments
Alt+Y+D+PSupporting Detail (Planning only)
Alt+Y+D+TDocument Attachment (Planning only)
Alt+Y+D+LLock (Planning only)
Alt+Y+D+CCalculate
Alt+Y+D+C+BCalculate, Business Rules (Planning only)
Alt+Y+D+C+UCalculate, Rules on Form (Planning only)
Alt+Y+D+C+DCalculate, Calculate
Alt+Y+D+C+FCalculate, Force Calculate (HFM and Enterprise only)
Alt+Y+D+C+TCalculate, Translate (HFM and Enterprise only)
Alt+Y+D+C+RCalculate, Force Translate (HFM and Enterprise only)
Alt+Y+D+O+2Consolidate (HFM and Enterprise only)
Alt+Y+D+O+2+NConsolidate, Consolidate (HFM and Enterprise only)
Alt+Y+D+O+2+SConsolidate, Consolidate All (HFM and Enterprise only)
Alt+Y+D+O+2+LConsolidate, Consolidate All With Data (HFM and Enterprise only)
Alt+Y+D+O+2+AConsolidate, Calculate Contribution (HFM and Enterprise only)
Alt+Y+D+O+2+OConsolidate, Force Calculate Contribution (HFM only)
Alt+S+WView Comments
Alt+Y+D+UAdjust
Alt+Y+D+U+JAdjust, Adjust
Alt+Y+D+U+GAdjust, Grid Spread (Planning only)
Alt+Y+D+U+AAdjust, Mass Allocate (Planning only)
Alt+Y+D+DDrill-through
Alt+Y+D+MMore (Planning only)
Alt+Y+D+M+JMore, Job Console (Planning only)
Alt+Y+D+M+MMore, Member Formula (Planning only)
Alt+Y+D+M+IMore, Instructions (Planning only)
Alt+Y+D+M+FMore, Offline (Planning only)
Alt+Y+D+M+F+TMore, Offline, Take Offline (Planning only)
Alt+Y+D+M+F+YMore, Offline, Sync Back to Server (Planning only)
Alt+Y+D+M+F+RMore, Offline, Refresh Offline Definition (Planning only)
Alt+Y+W+PApprovals (Planning only)
Alt+Y+W+VCopy Version (Planning only)

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

KeysAction
Alt+Y+A+ZZoom In
Alt+Y+A+Z+NZoom In, Next Level
Alt+Y+A+Z+AZoom In, All Levels
Alt+Y+A+Z+BZoom In, Bottom Level
Alt+Y+A+Z+EZoom In, Same Level (Essbase only)
Alt+Y+A+Z+LZoom In, Sibling Level (Essbase only)
Alt+Y+A+Z+GZoom In, Same Generation (Essbase only)
Alt+Y+A+Z+FZoom In, Formulas (Essbase only)
Alt+Y+A+UZoom Out
Alt+Y+A+TPivot
Alt+Y+A+T+PPivot, Pivot
Alt+Y+A+T+TPivot Pivot to POV
Alt+Y+A+KKeep Only
Alt+Y+A+ORemove Only
Alt+Y+A+IMember Selection
Alt+Y+A+QQuery
Alt+Y+A+Q+QQuery, Query Designer
Alt+Y+A+Q+RQuery, Run Report
Alt+Y+A+Q+EQuery, Execute MDX (Essbase only)
Alt+Y+A+Q+DQuery, Data Filter
Alt+Y+A+EMember Information (Essbase only)
Alt+Y+A+PPreserve Format (except Enterprise Ad Hoc)
Alt+Y+A+AChange Alias (Essbase only)
Alt+Y+A+DData Perspective (Essbase only)
Alt+Y+A+SSmart Slice (except Enterprise)
Alt+Y+A+CCascade (except Enterprise Ad Hoc)
Alt+Y+A+C+SCascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+A+C+NCascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+A+C+DCascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+D+RRefresh
Alt+Y+D+R+R Refresh, Refresh
Alt+Y+D+R+ARefresh, Refresh All
Alt+Y+D+OPOV
Alt+Y+D+WView Comments
Alt+Y+D+CCalculate
Alt+Y+D+ZVisualize (Essbase only)
Alt+Y+D+Z+EVisualize, Visualize in Excel (Essbase only)
Alt+Y+D+DDrill-through
Alt+Y+JLinked Objects (Essbase only)
Alt+Y+D+UAdjust
Alt+Y+D+BSubmit Data

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

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

Office 2003 Menu Keyboard Equivalents

Microsoft Office 2003 products do not have ribbons. Table 10 displays the keyboard equivalents for items on the Office 2003 Smart View menu.

Table 10. Smart View Menu Keyboard Equivalents

KeysAction
Alt+S+PPanel
Alt+S+CConnections
Alt+S+C+TConnections, Active Connections
Alt+S+C+EConnections, Reset to Default Connection
Alt+S+C+OConnections, Reporting and Analysis Document
Alt+S+C+O+EConnections, Reporting and Analysis Document, Edit
Alt+S+C+UConnections, Recently Used
Alt+S+EEdit
Alt+S+E+NEdit, Undo
Alt+S+E+DEdit, Redo
Alt+S+E+CEdit, Copy Data Point
Alt+S+E+VEdit, Paste Data Point
Alt+S+E+MEdit, Manage POV
Alt+S+E+BEdit, Build Function
Alt+S+DData
Alt+S+RData, Refresh All Worksheets
Alt+S+D+OData, POV
Alt+S+D+EData, Cell Comments
Alt+S+D+PData, Supporting Details
Alt+S+D+TData, Cell Attachment
Alt+S+D+HData, Cell History
Alt+S+D+DData, Drill-through
Alt+S+D+LData, Lock
Alt+S+D+BData, Submit Data
Alt+S+D+CData,Calculate
Alt+S+D+C+CData, Calculate, Calculate
Alt+S+D+C+FData, Calculate, Force Calculate
Alt+S+D+C+TData, Calculate, Translate
Alt+S+D+C+RData, Calculate, Force Translate
Alt+S+D+C+BData, Calculate, Business Rules
Alt+S+D+C+UData, Calculate, Rules on Form
Alt+S+D+OData, Consolidate
Alt+S+D+O+NData, Consolidate, Consolidate
Alt+S+D+O+SData, Consolidate, Consolidate All
Alt+S+D+O+AData, Consolidate, Calculate Contribution
Alt+S+D+O+OData, Consolidate, Force Calculate Contribution
Alt+S+D+O+LData, Consolidate, Consoildate All With Data
Alt+S+D+UData, Adjust
Alt+S+D+U+JData, Adjust, Adjust
Alt+S+D+U+GData, Adjust, Grid Spread
Alt+S+D+U+AData, Adjust, Mass Allocate
Alt+S+D+VData, Visualize
Alt+S+D+V+EData, Visualize, Visualize in Excel
Alt+S+D+WData, View Comments
Alt+S+D+JData, Job Console
Alt+S+D+MData, Member Formula
Alt+S+D+IData, Instructions
Alt+S+D+FData, Offline
Alt+S+D+F+TData, Offline, Take Offline
Alt+S+D+F+YData, Offline, Sync Back To Server
Alt+S+D+F+RData, Offline, Refresh Offline Definition
Alt+S+AAnalysis
Alt+S+A+ZAnalysis, Zoom In
Alt+S+A+Z+ZAnalysis, Zoom In, Zoom In
Alt+S+A+Z+NAnalysis, Zoom In, Next Level
Alt+S+A+Z+AAnalysis, Zoom In, All Level
Alt+S+A+Z+BAnalysis, Zoom In, Bottom Level
Alt+S+A+Z+EAnalysis, Zoom In, Same Level
Alt+S+A+Z+LAnalysis, Zoom In, Sibling Level
Alt+S+A+Z+GAnalysis, Zoom In, Same Generation
Alt+S+A+UAnalysis, Zoom Out
Alt+S+A+KAnalysis, Keep Only
Alt+S+A+OAnalysis, Remove Only
Alt+S+A+VAnalysis, Pivot
Alt+S+A+TAnalysis, Pivot To POV
Alt+S+A+SAnalysis, Smart Slice
Alt+S+A+SAnalysis, Save ad Hoc to Grid (Planning)
Alt+S+A+CAnalysis, Cascade
Alt+S+A+C+SAnalysis, Cascade, Same Workbook
Alt+S+A+C+NAnalysis, Cascade, New Workbook
Alt+S+A+C+DAnalysis, Cascade, Different Workbooks
Alt+S+A+QAnalysis, Query
Alt+S+A+Q+QAnalysis, Query, Query Designer
Alt+S+A+Q+RAnalysis, Query, Run Report
Alt+S+A+Q+EAnalysis, Query, Execute MDX
Alt+S+A+Q+DAnalysis, Query, Data Filter
Alt+S+A+EAnalysis, Member Information
Alt+S+A+PAnalysis, Preserve Format
Alt+S+A+AAnalysis, Change Alias
Alt+S+A+IAnalysis, Member Selection
Alt+S+A+DAnalysis, Data Perspective
Alt+S+A+MAnalysis, Add Member
Alt+S+WWorkflow
Alt+S+W+PWorkflow, Approvals
Alt+S+W+VWorkflow, Copy Version
Alt+S+QSmart Query. When the Smart Query menu is open, use the arrow keys to scroll through the menu items.
Alt+S+SOptions
Alt+S+FSheet Info
Alt+S+JLinked Objects
Alt+S+MMore
Alt+S+M+GMore, Migrate Active Workbook (Financial Management)
Alt+S+M+BMore, Migrate Batch (Financial Management)
Alt+S+M+RMore, Migrate Active Workbook (Hyperion Enterprise)
Alt+S+M+EMore, Migrate Batch (Hyperion Enterprise)
Alt+S+M+IMore, Insert Connection List
Alt+S+M+PMore, Import Metadata
Alt+S+D+OPOV
Alt+S+HHelp
Alt+S+H+CHelp, Contents
Alt+S+H+PHelp, Oracle User Productivity
Alt+S+H+SHelp, Technical Support
Alt+S+H+EHelp, EPM Documentation
Alt+S+H+ZHelp, About

Smart View Panel Navigation

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

Table 11. Smart View Panel Navigation

KeysAction
Alt+S+PLaunch the Smart View Panel (Office 2007 and 2010)
F6Switch between Smart View and Office components
TabScroll through Smart View Panel
Up and down arrow keysScroll through items in tree view
Left and right arrow keys

In toolbars - move through buttons

In tree views - expand or collapse a node

Alt+tabMove from tree view to Action Panel
Alt+down arrowOpen the drop-down menu
Up and down arrow keysScroll through drop-down list
EnterSelect an item in the drop-down menu
EscapeCancel selection
Alt+F4Close the Smart View Panel and move to grid (Office 2003)

Smart Query Panel Navigation

Table 12. Smart Query Panel Navigation

KeysAction
F6Switch 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

Table 13 shows the heyboard equivalents for Office 2010. Table 14 shows the heyboard equivalents for Office 2007.

Table 13. Smart Query Ribbon Keyboard Equivalents for Office 2010

KeyAction
Alt+Y+1+Y+3Analyze
Alt+Y+1+Y+4Designer Panel
Alt+Y+1+Y+5Copy
Alt+Y+1+Y+6Paste
Alt+Y+1+Y+7Save
Alt+Y+1+Y+8Open
Alt+Y+1+Y+9Refresh
Alt+Y+1+Y+AAutomatic Refresh
Alt+Y+1+Y+BChange Alias
Arrow key + EnterChange Alias, None
Arrow key + EnterChange Alias, More Alias Tables
Alt+Y+1+Y+CIndentation
Alt+Y+1+Y+DShow Distinct Member Names
Alt+Y+1+Y+ESuppress Rows with No Data

Table 14. Smart Query Ribbon Keyboard Equivalents for Office 2007

KeyAction
Alt+Y+Y+0+1Analyze
Alt+Y+Y+0+2Designer Panel
Alt+Y+Y+0+3Copy
Alt+Y+Y+0+4Paste
Alt+Y+Y+0+5Save
Alt+Y+Y+0+6Open
Alt+Y+Y+0+7Refresh
Alt+Y+Y+0+8Automatic Refresh
Alt+Y+Y+0+9Change Alias
Arrow key + EnterChange Alias, None
Arrow key + EnterChange Alias, More Alias Tables
Alt+Y+Y+1+0Indentation
Alt+Y+Y+1+1Show Distinct Member Names
Alt+Y+Y+1+2Suppress Rows with No Data