Specifying Member Layout in Worksheets

After member selection, you must define how you want the members to be displayed in the worksheet. You can select to:

Insert members down a column and before an active cell.
Insert members down a column, overwriting the active cell.
Insert members across a row and before an active cell.
Insert members across a row, overwriting the active cell.

To insert members down a column and before an active cell:

In Essbase Member Selection, select Place Down the Sheet.
Select Insert List Before Active Cell.
Click OK.

To insert members down a column, overwriting the active cell:

In Essbase Member Selection, select Place Down the Sheet.
Clear Insert List Before Active Cell.
Click OK.

To insert members across a row and before an active cell:

In Essbase Member Selection, clear Place Down the Sheet.
Select Insert List Before Active Cell .
Click OK.

To insert members across a row, overwriting the active cell:

In Essbase Member Selection, clear Place Down the Sheet.
Clear Insert List Before Active Cell.
Click OK.

Related Topics

Clearing All Member Selections

Previewing Members

Removing Members from Rules

Reordering Member Display in Worksheets

Saving Member Selections

Searching for Members

Selecting Members Using Attributes

Selecting Members to Add to Worksheets

Specifying Latest Period To-Date

Specifying Member Criteria

Specifying View Methods

Suppressing Shared Members

Viewing All Members

Viewing Member Formulas