Selecting Members by Attribute Association

You can select all base dimension members associated with one or more attributes using the <WITHATTR command. For example, you can display all products associated with a member of the Pkg Type attribute dimension. At the point in the script where you want to select the members, enter the following syntax:

<WITHATTR (attributeDimensionName, "Operator", Value)

The following command returns all base dimension members that are associated with the attribute Small from the Population attribute dimension.

<WITHATTR (Population, "IN", Small)

The following command returns all base dimension members that are associated with the attribute 32 from the Ounces attribute dimension.

<WITHATTR (Ounces, "<", 32)

Note:

The <WITHATTR command can be used within the LINK command to refine member selections, as illustrated in the following example: <LINK ((<WITHATTR (Ounces, "<", 32) AND <WITHATTR ("Pkg Type", "=", Can))

For a sample report, see “Sample 21: Using the WITHATTR Command in Member Selection” in the Oracle Essbase Technical Reference.