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
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.
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.
The replacement labels specified in the Data Options page of Smart View 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 duplicate member Essbase data source, select Member Name Only 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.
For Hyperion Enterprise data sources, you cannot type dimension names in the free-form grids. You can type only member names.
Dynamic Time Series members (Essbase) must use one of the following formats:
Q-T-D(Jan)
Y-T-D(Mar)
M-T-D(Jun)