Keyboard Equivalents in Dialog Boxes and Editors

The tables in this section describe keyboard equivalents found in Essbase Studio Console dialog boxes and editors.

Table 13. Keyboard Equivalents for the Essbase Studio Login Dialog Box

Element Name	Equivalent
Server	Alt+S
User	Alt+U
Password	Alt+P
Remember this user	Alt+R

Note:

The Essbase Studio Login dialog box is also launched when users select Tools, then Reconnect To Server (Alt+T, then R).

Table 14. Keyboard Equivalents for Connection Wizard, Define Connection Page

Element Name	Equivalent
Connection name	Alt+C
Connection Description	Alt+O
Data Source Type	Alt+D
Presentation Layer (Oracle BI EE sources only)	Alt+L
Business Model (Oracle BI EE sources only)	Alt+M
Essbase Server (Essbase Server connections only)	Alt+V
Server Name	Alt+V
Default (port number)	Alt+E
Cluster (Essbase Server connections only)	Alt+L
SID	Alt+I
Service Name	Alt+R
Pool Max Size	Alt+X
Cache Size	Alt+Z
Authentication Method	Alt+H
User Name	Alt+U
Password	Alt+P
Database Name	Alt+A
Browse (for text file location)	Alt+W
Skip records (text file sources only)	Alt+K
Column names in first row (text file sources only)	Alt+R
Comma (text file sources only)	Alt+M
Tab (text file sources only)	Alt+A
Space (text file sources only)	Alt+P
Custom (text file sources only)	Alt+U
Test Connection	Alt+T

Table 15. Keyboard Equivalents for Connection Wizard, Select Tables Page

Element Name	Equivalent
Filter	Alt+T
Apply	Alt+A
Lock catalog during exploration	Alt+L

Table 16. Keyboard Equivalents for Connection Wizard, Model Files Page (text file data sources only)

Element Name	Equivalent
Select all	Alt+S
Clear all	Alt+C
Filter	Alt+T
Skip records	Alt+K
Column names in first row	Alt+R
Comma	Alt+M
Tab	Alt+A
Space	Alt+P
Custom	Alt+U
Edit Column Properties	Alt+E

Table 17. Keyboard Equivalents for Column Properties Dialog Box (accessed from the Connection Wizard, Model Files Page)

Element Name	Equivalent
Name	Alt+M
Data type	Alt+D, then use the arrow keys to select an option: Text Integer Large integer Decimal
Back	Alt+B
Next	Alt+N

Table 18. Keyboard Equivalents for Connection Wizard, Select Minischema Page

Element Name	Equivalent
Create a new schema diagram	Alt+C
Reuse an existing schema diagram	Alt+R
Clear existing schema	Alt+X
Skip minischema diagram	Alt+S
Use Introspection to Detect Hierarchies	Alt+I

Table 19. Keyboard Equivalents for Connection Wizard, Populate Minischema Page

Element Name	Equivalent
Connections	Alt+C
Databases	Alt+D
Filter	Alt+T
Apply	Alt+A
Add Related Objects	Alt+R

Table 20. Keyboard Equivalents for Connection Wizard, Create Metadata Elements Page or Create OBIEE Dimension Elements Page

Element Name	Equivalent
Browse	Alt+W

Table 21. Keyboard Equivalents for Minischema Wizard, Name and Description Page

Element Name	Equivalent
Minischema Name	Alt+M
Minischema Description	Alt+D

Table 22. Keyboard Equivalents for Minischema Wizard, Add/Remove Tables Page

Element Name	Equivalent
Connections	Alt+C
Filter	Alt+T
Apply	Alt+A
Add Related Tables	Alt+R

Table 23. Keyboard Equivalents for Edit Properties of Minischema Join Dialog Box

Element Name	Equivalent
Table	Alt+T
Column	Alt+C
Outer	Alt+O
Left	Alt+L
Full	Alt+F
Right	Alt+R

Table 24. Keyboard Equivalents for Create Joins by Inspection Dialog Box

Element Name	Equivalent
Table name filter	Alt+T
Column name filter	Alt+C
Select all items	Alt+S

Table 25. Keyboard Equivalents for User-Defined Table Definition Dialog Box

Element Name	Equivalent
Connection	Alt+C
Table name	Alt+T
Table definition	Alt+D

Table 26. Keyboard Equivalents for Rehost Essbase Connections Dialog Box

Element Name	Equivalent
Update the host name and port number for all deployment history	Alt+D
Replicate the last successful deployment history and update the copy only	Alt+R
Test Connection	Alt+T
Update	Alt+U
Close	Alt+C

Table 27. Keyboard Equivalents for Preferences Dialog Box, General

Element Name	Equivalent
Show Confirm Delete dialog	Alt+C
Show informational messages	Alt+I
Show warning messages	Alt+W
Show error messages	Alt+E
Browse	Alt+B
Restore Defaults	Alt+D
Apply	Alt+A

Table 28. Keyboard Equivalents for Preferences Dialog Box, Schema

Element Name	Equivalent
Column type indicator	Alt+T
Primary Key	Alt+P
Foreign Key	Alt+F
Diagonal	Alt+G
Rectangle	Alt+R
Arrow	Alt+O
Crow's Feet	Alt+W
Restore Defaults	Alt+D
Apply	Alt+A

Table 29. Keyboard Equivalents for Preferences Dialog Box, Essbase Model

Element Name	Equivalent
Ask user if the model should be tuned when setting aggregate storage to true	Alt+M
Ask user to validate a changed model before closing the Properties dialog box	Alt+V

Table 30. Keyboard Equivalents for Folder Properties Dialog Box

Element Name	Equivalent
Name	Alt+N
Description	Alt+D

Table 31. Keyboard Equivalents for Dimension Element Properties Dialog Box

Element Name	Equivalent
Name	Alt+N
Description	Alt+D
Formula	Alt+F
Caption Binding	Alt+C
Key Binding option: Same as caption	Alt+S
Key Binding option: Advanced	Alt+A
Key Binding option: Delayed	Alt+Y
Filter	Alt+T
Sort Order	Alt+O

Table 32. Keyboard Equivalents for Derived Text Measure Properties Dialog Box

Element Name	Equivalent
Name	Alt+N
Description	Alt+D
Formula	Alt+F
Expression	Alt+E
Range	Alt+R Note: Use Alt+R when rows are present in the Range table. When the Range table is empty, tab to the Add another row button to begin adding rows to the table.

Table 33. Keyboard Equivalents for Text List Properties Dialog Box

Element Name	Equivalent
Name	Alt+N
Description	Alt+D
Bindings	Alt+B
Value Binding	Alt+V
ID Binding	Alt+I

Table 34. Keyboard Equivalents for Hierarchy and Measure Hierarchy Editor

Element Name	Equivalent
Name	Alt+N
Description	Alt+D
Data	Alt+T
Add	Alt+A
Preview With Caption Binding (not available for measure hierarchies)	Alt+P+C
Preview With Key Binding (not available for measure hierarchies)	Alt+P+K
Add child	Alt+A Or Insert
Add sibling	Alt+S Or Shift+Insert
Add user-defined child	Alt+C Or Ctrl+Insert
Add user-defined sibling	Alt+U Or Ctrl+Shift+Insert

Table 35. Keyboard Equivalents for Calendar Hierarchy Dialog Box

Element Name	Equivalent
Hierarchy Name	Alt+H
Gregorian	Alt+G
Fiscal	Alt+F
Retail	Alt+R
ISO	Alt+I
Manufacturing	Alt+M
Start Date	Alt+S
End Date	Alt+D
First day of week	Alt+W
Time Depth	Alt+T
Edit	Alt+E
Day Attributes	Alt+A
Edit LVA	Alt+V

Table 36. Keyboard Equivalents for Day Attributes Dialog Box

Element Name	Equivalent
Sunday	Alt+S
Monday	Alt+M
Tuesday	Alt+T
Wednesday	Alt+W
Thursday	Alt+H
Friday	Alt+F
Saturday	Alt+U
Dimension Name	Alt+D
Add	Alt+A
Remove	Alt+R

Table 37. Keyboard Equivalents for Edit Linked Value Attributes Dialog Box

Element Name	Equivalent
Linked Value Attributes	Alt+L, then use the Tab key to tab through the options.

Table 38. Keyboard Equivalents for Edit Labeling Rules

Element Name	Equivalent
Use 2-digit time entity	Alt+U

Table 39. Keyboard Equivalents for Create Date Elements Dialog Box

Element Name	Equivalent
Year	Alt+Y
Quarter	Alt+Q
Month	Alt+M
Day of week	Alt+D

Table 40. Keyboard Equivalents for Alias Set Manager

Element Name	Equivalent
Alias sets	Alt+A
Description	Alt+D
Bindings	Alt+B
Bindings popup menu	Alt+B, Shift+F10 The Bindings popup menu has these options: N—Sort by dimension element name P—Sort by dimension element path B—Sort by bindings A—Sort ascending D—Sort descending F—Show full path for dimension elements

Table 41. Keyboard Equivalents for the Create Bindings Dialog Box

Element Name	Equivalent
Source selection tree	Alt+S
Binding expression	Alt+X
Binding expression tree	Alt+B

Table 42. Keyboard Equivalents for Cube Schema Wizard, Choose Measures and Hierarchies Page

Element Name	Equivalent
Cube Schema Name	Alt+S
Comment	Alt+C
Available Dimension Elements	Alt+A
Measures/Measures Hierarchy	Alt+M
Hierarchies	Alt+H
Preview Hierarchies	Alt+P

Table 43. Keyboard Equivalents for Cube Schema Wizard, Cube Schema Options Page

Element Name	Equivalent
Override default data load bindings	Alt+O
Create Essbase Model	Alt+C
Model Name	Alt+M
Account Dimension	Alt+D
Model Type: Aggregate Storage	Alt+A
Model Type: Block Storage	Alt+S

Table 44. Keyboard Equivalents for Default Load Binding Dialog Box

Element Name	Equivalent
Formula	Alt+U
Expression	Alt+E
Filter	Alt+F

Note:

To access the Default Load Binding dialog box: In the Define data load mappings page of the Cube Schema Wizard, use the up and down arrow keys to navigate to the leaf level of a hierarchy, use the right arrow key to move to the Data Load Binding column, and press Enter to activate the cell. Press Enter again to activate the ellipsis button and launch the Default Load Binding dialog box.

Table 45. Keyboard Equivalents for Essbase Model Properties, General Tab

Element Name	Equivalent
Comment	Alt+M
Last deployed	Alt+L
Aggregate storage model	Alt+A
Duplicate member name support	Alt+D
Use Unicode character set	Alt+U
XOLAP Model	Alt+X
Custom data load settings	Alt+S, launches the Define Data Load Settings dialog box
Date format	Alt-F

Table 46. Keyboard Equivalents for Essbase Model Properties, Alias Tab

Element Name	Equivalent
Available Tables	Alt+A
Selected Tables	Alt+S

Table 47. Keyboard Equivalents for Essbase Model Properties, Attributes Tab

Element Name	Equivalent
Value	Alt+V
Prefix/Suffix	Alt+P
Separator	Alt+S
Dimension	Alt+D
Sum member	Alt+U
Count member	Alt+T
Minimum member	Alt+M
Maximum member	Alt+X
Average member	Alt+G
True members	Alt+E
Dates are	Alt+A
False members	Alt+F
Numerics are	Alt+R

Table 48. Keyboard Equivalents for Essbase Model Dimension Properties, General Tab

Element Name	Equivalent
Name in Cube	Alt+N
Comment	Alt+M
Edit Named Generations and Levels	Alt+E

Table 49. Keyboard Equivalents for Essbase Model Dimension Properties, Edit Named Generational and Levels Dialog Box

Element Name	Equivalent
Named Generations	Alt+G
Named Levels	Alt+L

Table 50. Keyboard Equivalents for Essbase Model Dimension Properties, Info Tab

Element Name	Equivalent
Dimension Type	Alt+T
Dynamic series	Alt+Y
Dimension Storage	Alt+D
Two Pass Calculation	Alt+P
Data Storage	Alt+S
Dimension Solve Order	Alt+V
Member Solve Order	Alt+M

Table 51. Keyboard Equivalents for Essbase Model Dimension Properties, Account Info Tab

Element Name	Equivalent
Time Balance	Alt+T
Skip	Alt+S
Variance Reporting	Alt+V

Table 52. Keyboard Equivalents for Essbase Model Dimension Properties, Formula Tab

Element Name	Equivalent
Formula	Alt+F

Table 53. Keyboard Equivalents for Essbase Model Dimension Properties, UDAs Tab

Element Name	Equivalent
UDA value	Alt+U
Add to list	Alt+A
Existing UDAs	Alt+E

Table 54. Keyboard Equivalents for Essbase Model Dimension Properties, Outline Build Tab

Element Name	Equivalent
Hierarchy settings	Alt+H
Move duplicate member settings	Alt+M
Optimize data load by using a fact table column as data source binding	Alt+Z
Reverse position of shared and actual members if shared member is located before actual member	Alt+R

Table 55. Keyboard Equivalents for Essbase Model Member Properties, General Tab

Element Name	Equivalent
Comments	Alt+M
Essbase attribute for <member name>	Alt+A
Attribute dimension name	Alt+D
Attribute type	Alt+T
Edit Varying Attribute Settings	Alt+E
Edit Named Generations and Levels	Alt+I

Table 56. Keyboard Equivalents for Essbase Model Properties, Edit Varying Attributes Dialog Box

Element Name	Equivalent
Create as Varying Attribute	Alt+C
Association mode	Alt+A
Independent Dimension Settings	Alt+I

Table 57. Keyboard Equivalents for Essbase Model Member Properties, Info Tab

Element Name	Equivalent
Consolidation	Alt+D
Solve Order	Alt+V
Aggregate Storage Options	Alt+A
Two Pass Calculation	Alt+P
Data Storage	Alt+S

Table 58. Keyboard Equivalents for Essbase Model Member Properties, Account Info Tab

Element Name	Equivalent
Time Balance	Alt+T
Variance Reporting	Alt+V
Skip	Alt+S

Table 59. Keyboard Equivalents for Essbase Model Member Properties, Typed Measures Tab

Element Name	Equivalent
Member format string	Alt+F
Current Assigned Text List	Alt+A
Clear Current Assigned Text List	Alt+L

Table 60. Keyboard Equivalents for Essbase Model Member Properties, Formula Tab

Element Name	Equivalent
Formula	Alt+F

Table 61. Keyboard Equivalents for Essbase Model Member Properties, Alias Tab

Element Name	Equivalent
Rules for mapping text replacement	Alt+R
Create rule	Alt+A
Edit details	Alt+E
Delete	Alt+D
Change case to	Alt+H
Drop leading and trailing spaces	Alt+L
Convert spaces to underscores	Alt+V
Prefix	Alt+P
Prefix Separator	Alt+F
Custom prefix	Alt+X
Suffix	Alt+S
Suffix separator	Alt+U
Custom suffix	Alt+M

Table 62. Keyboard Equivalents for Essbase Model Member Properties, Alias Tab—Search Rule Dialog Box

Element Name	Equivalent
Search for	Alt+S
Replace with	Alt+R
Case sensitive	Alt+C
Match whole word	Alt+M
Replace all occurrences	Alt+A

Table 63. Keyboard Equivalents for Essbase Model Member Properties, UDAs Tab

Element Name	Equivalent
UDA value	Alt+U
External source	Alt+X
Existing UDAs	Alt+E
UDA Value—Add to list	Alt+A
External Source—Add to list	Alt+D

Table 64. Keyboard Equivalents for Essbase Model Member Properties, Transformations Tab

Element Name	Equivalent
Prefix	Alt+P
Prefix separator	Alt+F
Custom prefix	Alt+T
Suffix	Alt+S
Suffix separator	Alt+I
Custom suffix	Alt+X
Rules for text replacement	Alt+R
Create rule	Alt+U
Edit details	Alt+E
Delete	Alt+D
Drop leading and trailing spaces	Alt+A
Convert spaces to underscores	Alt+V

Table 65. Keyboard Equivalents for Essbase Model Member Properties, Transformation Tab—Search Rule Dialog Box

Element Name	Equivalent
Search for	Alt+S
Replace with	Alt+R
Case sensitive	Alt+C
Match whole word	Alt+M
Replace all occurrences	Alt+A

Table 66. Keyboard Equivalents for Cube Deployment Wizard, Essbase Server Connection Options Page

Element Name	Equivalent
Essbase Server Connection	Alt+E
Application	Alt+A
Database	Alt+D
New Connection	Alt+W
ODBC (Essbase dynamically creates ODBC connection string)	Alt+O
ODBC (Enter ODBC DSN name)	Alt+C
OCI (Enter OCI connection identifier)	Alt+I
Model Properties	Alt+M

Table 67. Keyboard Equivalents for Essbase Login Dialog Box (accessed when creating an Essbase Server connection in the Cube Deployment Wizard)

Element Name	Equivalent
Name	Alt+N
Description	Alt+D
Server	Alt+S
Port	Alt+T
User	Alt+U
Password	Alt+P
Cluster	Alt+C

Table 68. Keyboard Equivalents for Cube Deployment Wizard, Cube Deployment Options Page

Element Name	Equivalent
Build outline	Alt+U
Load data	Alt+L
Build outline and load data	Alt+O
Add to existing data	Alt+X
Subtract from existing data	Alt+S
Overwrite existing data	Alt+G
Delete all members first	Alt+M
Delete and restore database	Alt+R
Incremental load	Alt+I
Create and save rule file only	Alt+C
Number of records to keep: All	Alt+A
Number of records to keep: Limit	Alt+T
Error file name: Default	Alt+D
Error file name: File name	Alt+E
Stop the data load when the first record is rejected	Alt+P
Deploy now	Alt+Y
Save as MaxL load script	Alt+V
Browse	Alt+W

Table 69. Keyboard Equivalents for Cube Deployment Wizard, Incremental Load Page

Element Name	Equivalent
Update all hierarchies	Alt+H
Update or rebuild selected hierarchies	Alt+S
Update	Alt+U
Rebuild	Alt+R
Clear	Alt+C
Preserve	Alt+P

Table 70. Keyboard Equivalents for Drill-through Report Editor, Context Tab

Element Name	Equivalent
Name	Alt+N
Description	Alt+D
Intersections	Alt+I
Add	Alt+A
Advanced Settings (applies to recursive hierarchies only)	Alt+G

Table 71. Keyboard Equivalents for Drill-through Report Editor, Report Contents Tab—Report Type: Relational

Element Name	Equivalent
Report Type: Relational	Alt+R
Add	Alt+A
Show duplicate records in report	Alt+P
User user-defined SQL	Alt+D
Template SQL	Alt+Q
Filter	Alt+L
Row governor	Alt+V
Test	Alt+S

Table 72. Keyboard Equivalents for Drill-through Template SQL Dialog Box

Element Name	Equivalent
Cube Schema	Alt+S
Get Standard SQL	Alt+G
User-defined SQL	Alt+Q
Validate	Alt+V
Update User-defined SQL	Alt+U

Table 73. Keyboard Equivalents for Drill-through Filter Dialog Box

Element Name	Equivalent
Formula	Alt+F
Filter Expression	Alt+X

Table 74. Keyboard Equivalents for Drill-through Report Testing Dialog Box

Element Name	Equivalent
Cube Schema	Alt+S
Column value for each intersection	Alt+I
Show result	Alt+R
Maximum rows to display	Alt+M
Resulting report	Alt+T

Table 75. Keyboard Equivalents for Drill-through Report Editor, Report Contents Tab—Report Type: URL

Element Name	Equivalent
Report Type: URL	Alt+U
URL	Alt+L
Sample URL Template	Alt+S
FDM URL Template	Alt+F
OBI URL Template	Alt+O

Table 76. Keyboard Equivalents for Drill-through Report Editor , Report Contents Tab—Report Type: Java Method

Element Name	Equivalent
Report Type: Java Method	Alt+J
Java Class Name	Alt+C
Java Method Name	Alt+M

Table 77. Keyboard Equivalents for Drill-through Report Editor, Associations Tab

Element Name	Equivalent
Select all Essbase models	Alt+A
Refresh Model List	Alt+R

Table 78. Keyboard Equivalents for Update Cube Linkage and Cube Linkage Dialog Boxes

Element Name	Equivalent
Update all Essbase applications and databases to link to the current Studio Server (all Essbase instances must be started)	Alt+P
Stop all Essbase applications after the update	Alt+S
Update selected Essbase application and database	Alt+D
Update	Alt+U Note: You must first have selected an application and database, listed under Essbase Connections in the table.
Essbase Studio Server	Alt+S
Essbase model name	Alt+M

Table 79. Keyboard Equivalents for Export Dialog Box

Element Name	Equivalent
File Name	Alt+N
File Description	Alt+D
Browse	Alt+W
File Contents	Alt+C
Export entire catalog	Alt+E
Export partial catalog (use the Add Button to select elements)	Alt+P
Add, then Add Metadata	Alt+A, then M
Add, then Add Data Source	Alt+A, then D
Include associated Essbase models with Cube Schemas	Alt+I

Table 80. Keyboard Equivalents for Import Dialog Box

Element Name	Equivalent
Browse	Alt+W
Check for elements and overwrite them	Alt+C
Check for elements but do not overwrite them	Alt+K
Do not check for elements; all elements are new	Alt+E

Table 81. Keyboard Equivalents for the EIS Catalog Migration Dialog Box

Element Name	Equivalent
EIS Catalog ODBC DSN	Alt+E
User	Alt+U
Password	Alt+P
Fetch Models	Alt+F
New Data Source	Alt+N
Browse	Alt+B
In Select Folder dialog box: Create Folder	Alt+F
Migrate	Alt+M

Table 82. Keyboard Equivalents for the Find Dialog Box

Element Name	Equivalent
Find	Alt+F
Match Case	Alt+C
Match Word	Alt+W
Apply to current selection	Alt+A