Entering Members in Free-Form Mode

If you are familiar with the dimensions and members of your database, you can enter their names directly into cells using free-form mode.

You can use aliases from the alias table associated with the current grid in free-form mode.

Note:

Oracle Essbase, Oracle Enterprise Performance Management Cloud Ad Hoc:

If you enter an alias from a different alias table, it will revert to the alias from the current alias table.

After connecting to a data source, you can enter member names as follows:

  • By entering a member name in a blank cell

  • By replacing a member name in a cell with a different member from the same dimension

You can still use the POV, member selection, and other ad hoc operations in free-form grids. See Free-Form Mode.