Ad hoc grids start with the following properties:
Dimension root members are selected.
Account is on the row axis.
Period and Year are on the column axis.
Other dimensions in the application are on the page axis, where they are selectable from a drop-down list. (Ad hoc grids have no POV axis.)
Dimension and member properties (for example, Data Type) are retained.
Rows and column groupings are retained.
After opening an ad hoc grid, users can then change which members display, pivot the axis, and analyze the data using ad hoc features (see Performing Ad Hoc Actions).
Note:
Properties that users set are in effect only for the current session.
The properties of the data form from which the ad hoc grid is originally invoked are not retained.