CubeQuery Menu Command Reference

The following table is a quick reference to the commands and shortcuts.

Table 70. CubeQuery Menu Commands

Command	Description	Keyboard Shortcut	Shortcut Menu	Query Menu	Double-click Enabled
Retrieve Dimensions	Refreshes the dimension values in the Catalog	F9		*
Add to Rows	Adds selected item to the Rows pane in the data layout		*	*
Add to Columns	Adds selected item to the Columns pane in the data layout		*	*
Add to Filters	Adds the selected item to the Filters pane in the data layout		*	*
Drill Down	Retrieves more detail from the selected member		*	*	*
Drill Up	Drills up to less dimension detail for the selected member		*	*	*
Drill Next	Retrieves data for the children of the selected member or members		*	*
Drill Bottom	Retrieves data from the lowest level descendants of the selected member		*	*
Drill All Descendants	Retrieves all descendants of the selected member		*	*
Drill Sibling	Retrieve data for the siblings of the selected member or members		*	*
Drill Same Level	Retrieves data for all members at the same level as the selected member or member		*	*
Drill Same Generation	Retrieves data for all members of the same generation as the selected member or members		*	*
Download to Results	Downloads the CubeQuery data set to an Results section for offline work			*
Show as Chart	Charts the CubeQuery data set; automatically creates an Chart and Results sections			*
Query Options	Accesses the Query Options dialog box, where you can set options for your CubeQuery			*
Keep Only	Clears all other dimension member selections for the selected Dimension, leaving only the selected member		*
Remove Only	Clears a dimension member, removing it from the query result set.		*
Suppress Missing Rows	Suppresses the return of data rows that contain only missing values. If one value is in the row, the row is not suppressed		*	*
Suppress Missing Columns	Suppresses the return of data columns that contain only missing columns. If one value is in the column, the column is not suppressed		*	*
Suppress Zero Rows	Suppresses the return of data rows that contain only zeros		*	*
Suppress Zero Columns	Suppresses the return of data columns that contain only zeros		*	*
Suppress Shared Members	Suppresses shared members from the query			*
Row Height	Modifies the row height by pixel size.		*
Column Width	Modifies the column width by pixel size:		*
Cancel Query		Alt+End