Free-Form Guidelines

  • Grids do not need to start in cell A1.

  • A grid must have at least one row dimension and one column dimension.

  • Each row dimension can contain members of only one dimension. Each column dimension can contain members of only one dimension.

  • Members of one dimension can be entered only in one of the following regions:

    • In the same row

    • In the same column

    • Anywhere in the page dimension region (Oracle Essbase only)

  • The page dimension region can contain members of different dimensions, but no two members in the page dimension region can belong to the same dimension (Essbase only).

  • Dimensions entered into the page dimension region override any corresponding default or existing dimensions in the page dimension region. For example, if the page dimension contains a Year dimension, and you enter Qtr1, then Qtr replaces Year in the page dimension (Essbase only).

  • The replacement labels specified in the Data Options page of Oracle Smart View for Office Options apply in free-form mode.

  • Numerical entries are identified as data in the data region, and as comments outside the data region. If you want to use a number as a member name, precede it with a single quotation mark; for example, '100.

  • Precede member names that contain spaces between words with a single quotation mark.

  • When connected to a database that supports duplicate member names, select Distinct Member Name on the Member Options page of the Smart View Options dialog box to display fully qualified member names in the worksheet. To enter duplicate members, use this syntax for qualified member names:

    [Income].[Other]
    [Expenses].[Other]
    
  • Aliases from the current alias table are permitted in free-form grids, but aliases from other alias tables are treated as comments.

  • Dynamic Time Series members (Essbase) must use one of the following formats:

    • Q-T-D(Jan)

    • Y-T-D(Mar)

    • M-T-D(Jun)