Pivot To: Moves a dimension to another area. For example, if you select this option within a row, you can move it to the Page axis or Column. You cannot pivot the last dimension in a row or column.
Move: Select an option to move a dimension Left, Right, Up, or Down. If an area has only one dimension, this option is unavailable.
Zoom In: Select an option to display the levels below a member of a hierarchy. For example, you can select to display the Next level, All levels, or Bottom level children.
Zoom Out: Displays the levels above a member of a hierarchy. For example, click a member and select Zoom Out to view the member's parents.
Remove Only: Removes the selected dimension or members from the ad hoc grid. More than one member of the dimension must be present on the grid.
Keep Only: Keeps only the selected members, and removes all other members from the dimension.
Select Members: Launches the Member Selection dialog box to select members. See Oracle Hyperion Planning Administrator's Guide.
Change Alias: Displays a list of alias tables from which to select.
You can control, at a global level, how ad hoc actions are performed or how the ad hoc grids are displayed. See Ad Hoc Grid Options.
See Saving Ad Hoc Grids.