Default Properties of New Ad Hoc Grids

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. (Ad hoc grids have no POV axis.)

After opening an ad hoc grid, you can change which members display, pivot the axis, and analyze the data using ad hoc features (see Performing Ad Hoc Actions).


  • Properties that you set are in effect only for the current session.

  • The properties of the form from which the ad hoc grid is originally invoked are not retained.