If you identify any columns in your data source
as containing elements, you must map those elements to the dimension
you are creating:
Procedure
- Click the Dimensions tab.
- Type Location in the Dimension field.
If multiple elements map to the same dimension, type the
dimension name for each element.
When you type a new dimension
name in the Dimension column, the Action column defaults to Create.
If
you type the name of an existing dimension, you have the option of
recreating or updating the dimension. If you choose the Recreate action,
the elements in the existing dimension are deleted and replaced by
the data in the data source. If you choose the Update action, the
dimension is updated with any new elements contained in the data source.
- Select a type for each element from the appropriate Element
Type menu. The element type indicates the type of data identified
by the element variable. In TM1® ,
this setting is almost always Numeric.
- Select an Element Order option.
The element order determines how elements are added to the dimension
during processing.
The data in this example contains
a single numeric element that maps to a new Location dimension. The
completed Dimensions tab displays as follows.