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)
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.