Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

231

232

233

234

235

236

237

238

239

240

Creating Analytic Grids Chapter 13

See Chapter 7, “Creating Cube Collections,” P resentation Cube Collections,

page 56.

Record Name

Select either a main record or an aggregate record from the cube collection.

The aggregate record is selected by default, if applicable. If there’s no

aggregate record, this field is populated with the main record. If you’ve

selected Freeze Column Mode, only w ork/derived records are displayed.

Analytic Instance

Specify the page field containing the analytic instance ID—that is, the instance

of the analytic model that is d isplayed in this analytic grid.

Non-Dimens

ional Fields

Select Slicer Axis to set the non-dimensional fields axis to the slicer axis.

Select Column Axis to set the non-dimensional fields axis to the column axis.

Select Row Axis to set the non-dimensional fields axis to the row axis.

Warning! All fields that are mapped to dimensions are considered dimensional

fields. All fields that are mapped to data cubes are considered non-dimensional

fields. The non-dimensional fields referred to within this dialog box are

mapped to data cubes. However, any field that is not mapped to anything is

also considered a non-dimensional field. If the application developer wants

to include such non-dimensional fields (those not mapped to anything) with

the analytic grid, he or she must populate them using the RowInit method

or their value will be zero.

Note. If a field is designated as invisible, that property is sometimes honored

and sometimes not honored within the analytic grid. If the field is a dimension

on the slicer axis, the property is honored. If the field is a dimension on the

row or column axis, the invisible property is not honored. If the field is a cube,

the invisible property is honored on the column but not the row axis.

Dimensional Fields

Use the Slicer Axis option to set which dimensional fields are used for the

slice bar.

Dimensions that have filter functions applied will behave differently

depending on whether they reside on the column axis/row axis or the slice

bar. See the following for details.

See C

hapter 10, “Creating Rules, Formulas, and User Functions,” Fil t er

User Functions, page 113.

Use the Column Axis option to set which dimensional fields are used for the

column axis.

Use the Row Axis option to set which dimensional fields are used for

the row axis.

You can select any dimensional field and move it from one list box to another

by using the appropriate arrow keys. (The arrow keys are grayed out if you do

not have a field selected.) The order of the fields on any particular axis—as

end users will see it—is determined by the order in which their columns

appear in the analytic grid, not by their order in the analytic model. You can

change the column order by using drag and drop. By default, all but the last

dimension appear on the slice bar axis; the last dimension appears on the row

axis, and the data cubes appear on the column axis.