Rules that define pick lists follow the same
conventions as all other TM1® rules.
As with other TM1 rules, a rule statement that defines
a pick list must include an area definition (the portion of the cube
to which the rule applies), a string qualifier, and a formula. In
the case of pick list rules, the formula is simply the pick list definition
that you want to apply.
Also as in all other TM1 rules, when multiple rule statements
apply to overlapping areas, the statements should be ordered from
most restrictive area to least restrictive area.
For more information
on creating rules, including details on specifying an area definition,
please see the IBM® Cognos® TM1 Rules
Guide.
Procedure
- In the Server Explorer, right-click the }Picklist control
cube for which you want to create a rule, then click Create
Rule.
The Rules Editor opens.
- Using a standard rules area definition, specify the cells
you want the pick list to appear in.
- Immediately after the area definition, type =S:.
This is the string qualifier, indicating that the rule applies to
string cells.
- Immediately after the string qualifier, enter a pick list
definition, enclosed in single quotes, then enclosed in parentheses.
For example, ('static:spring:summer:winter:fall').
- Immediately after the pick list definition, type a semi-colon
(;) to terminate the rule statement.
Using the procedure
described in these steps should result in a rule statement similar
to the following example, which indicates that an cell identified
by the fabric element will display a static pick list containing the
values wool, cotton, silk, and nylon.
['fabric']=S:('static:wool:cotton:silk:nylon');