Using the dimension, element, and attribute keywords
The ATTRN
and ATTRS
functions use the dimension,
element, and attribute keywords.
Procedure
- Type ATTRN and then press the Enter key. The dimension, element, and attribute keywords appear with the function.
ATTRN(dimension, element, attribute)
- Right-click the dimension keyword to display a list of dimensions in the current cube.
- Select a dimension from the list and then press the Enter key to insert the dimension
name into the function. You can also double click a dimension in the list to insert it into the
function.
The dimension name displays in the function, replacing the dimension keyword.
ATTRN('model', element, attribute)
- Right-click the element keyword to select an element.
The Subset Editor displays for the previously selected dimension.
- Select an element from the Subset Editor and click OK to return to
the Rules Editor. The element keyword is replaced with the element selected from the Subset Editor.
ATTRN('model', 'L Series 1.8l Wagon', attribute)
- Right-click the attribute keyword to display a list of attribute
names for the current dimension and element combination.
The specific attribute names that appear in this list depend on whether the function uses a string or numeric attribute. For example:
- When using the
ATTRN
function, the names of only numeric attributes appear in the list. - When using the
ATTRS
function, the names of only string attributes are shown. - If there are no valid attributes for the specific dimension, a blank list displays.
- When using the
- Select an attribute from the list. The attribute keyword is replaced in the formula with the attribute name that you selected from the list.
ATTRN('model', 'L Series 1.8l Wagon', 'Engine Size')