Connection Wizard and Connection Editing

Table 7-9 Keyboard Shortcuts for Connection Wizard, Define Connection Page

Keys	Element Name
Alt+C	Connection name
Alt+O	Connection Description
Alt+D	Data Source Type
Alt+L	Presentation Layer (Oracle Business Intelligence Enterprise Edition sources only)
Alt+M	Business Model (Oracle BI EE sources only)
Alt+V	Oracle Essbase Server (Essbase Server connections only)
Alt+V	Server Name
Alt+E	Default (port number)
Alt+L	Cluster (Essbase Server connections only)
Alt+I	SID
Alt+R	Service Name
Tab	If Oracle RAC is the Data Source Type: Press the Tab key to arrive at the Add RAC server node button
Tab	If Oracle RAC is the Data Source Type: Press the Tab key to arrive at the Remove RAC server node button
Alt+X	Pool Max Size
Alt+Z	Cache Size
Alt+H	Authentication Method
Alt+U	User Name
Alt+P	Password
Alt+A	Database Name
Alt+W	Browse (for text file location)
Alt+K	Skip records (text file sources only)
Alt+R	Column names in first row (text file sources only)
Alt+M	Comma (text file sources only)
Alt+A	Tab (text file sources only)
Alt+P	Space (text file sources only)
Alt+U	Custom (text file sources only)
Alt+T	Test Connection

Table 7-10 Keyboard Shortcuts for Connection Wizard, Select Tables Page

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

Table 7-11 Keyboard Shortcuts for Connection Wizard, Model Files Page (text file data sources only)

Table 7-12 Keyboard Shortcuts for Column Properties Dialog Box (accessed from the Connection Wizard, Model Files Page)

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

Table 7-13 Keyboard Shortcuts for Connection Wizard, Select Minischema Page

Keys	Element Name
Alt+C	Create a new schema diagram
Alt+S	Skip minischema diagram
Alt+I	Use Introspection to Detect Hierarchies

Table 7-14 Keyboard Shortcuts for Connection Wizard, Populate Minischema Page

Table 7-15 Keyboard Shortcuts for Connection Wizard, Create Metadata Elements Page or Create OBIEE Dimension Elements Page

Keys	Element Name
Alt+W	Browse
Alt+C	Create cube schema and Essbase model Note: This option is only available when creating an Oracle Business Intelligence Enterprise Edition data source.

Table 7-16 Keyboard Shortcuts for Connection Wizard, Create OBIEE Cube Schema Page

Keys	Element Name
Alt+S	Cube Schema Name
Alt+C	Comment
Alt+F	Available Fact Tables Use the arrow keys to expand folders and navigate to a column to select as a measure. Then, tab to the "Add selected measures" button, and press Enter. The column is moved to the Measures list.
Alt+M	Measures Use the arrow keys navigate to a column to remove from the list. Then, tab to the "Remove selected measures" button, and press Enter. The column is removed from the Measures list.
Alt+D	Available Dimension Elements Use the arrow keys navigate to a column to select as a hierarchy. Then, tab to the "Add selected hierarchies" button, and press Enter. The dimension is moved to the Hierarchies list.
Alt+H	Hierarchies Use the arrow keys navigate to a hierarchy to remove from the list. Then, tab to the "Remove selected hierarchies" button, and press Enter. The column is removed from the Hierarchies list.

Table 7-17 Keyboard Shortcuts for Refresh Data Source Tables Dialog Box

Keys	Element Name
Alt+T	Changed Tables
Alt+C	Changed Columns
Alt+D	Dependent Dimension Elements and Joins
Alt+F	Save Dependencies List as File
Alt+R	Refresh

Table 7-18 Keyboard Shortcuts for Delete Tables (from Data Source Connection) Dialog Box

Keys	Element Name
Alt+T	Table Status (Errors and Warnings)
Alt+A	Select All Tables
Alt+E	Dependent Dimension Elements and Joins
Alt+S	Save Dependencies List as File
Alt+D	Delete

Table 7-19 Keyboard Shortcuts for New Joins Dialog Box