Customizing the Column Layout

Each column in the Simplified dimension editor grid represents a member property (Member Name, Parent Member, Default Data Storage, and so on). The columns that initially display on the grid can be different based on which dimension type you are editing. You can customize the layout of columns in the Simplified dimension editor grid by hiding, unhiding, or resizing columns.

You can customize the layout of columns in the Edit Member Properties grid by hiding, unhiding, resizing, or reordering columns. You can also display the complete set of properties (all columns) by selecting Select All in the Select Columns dialog box.

The properties listed in the column selector are not a flat list of properties. Instead, properties are grouped in the column selector according to their functionality. For example, Account-specific properties such as Account Type, Variance Reporting, and Time Balance, are grouped under Account in the column selector. When you select Account in the column selector, all properties in the group are selected for inclusion in the grid. Then you can clear the checkboxes for any properties that you don't want added to the grid.

To customize the column layout in the Simplified dimension editor grid:

  1. View Edit Member Properties.

    See Accessing the Simplified Dimension Editor.

    Each column in the Edit Member Properties grid represents a member property. The list of properties (columns) that initially displays on the grid can be different based on which dimension type you're editing. You can customize the layout of columns in the rid by hiding, unhiding, or resizing columns. You can also display the complete set of properties (all columns) by selecting Select All in the Select Columns dialog box.

  2. On the dimension grid, right-click any column heading.

    A checklist of columns displays. Also displayed are column or grid resizing options.

  3. Select or clear the check boxes for the columns you want to hide or unhide on the grid.

    Each column in the Edit Member Properties grid represents a member property. The list of properties (columns) that initially displays on the grid can be different based on which dimension type you're editing. You can customize the layout of columns in the rid by hiding, unhiding, or resizing columns. You can also display the complete set of properties (all columns) by selecting Select All in the Select Columns dialog box.

  4. To change the size of the grid or the columns that are displayed on the grid, select or clear the following resizing options:
    • Force fit columns—Resizes the columns so that all columns are visible on the grid without scrolling.

    • Synchronous resize—Resets the size of the grid to original settings.