In addition to using the Attribute Calculations dimension to calculate attribute data, you can use calculation formulas on members of standard or base dimensions to perform specific calculations on members of attribute dimensions; for example, to determine profitability by ounce for products sized by the ounce.
You cannot associate formulas with members of attribute dimensions.
Some restrictions apply when using attributes in formulas associated with two-pass members. See the rows about two-pass calculations in Table 18, Differences Between Attribute and Standard Dimensions and Understanding Two-Pass Calculations on Attribute Dimensions. |
Table 25 lists functions you can use to perform specific calculations on attributes:
Table 25. Functions That Calculate On Attributes
Generate a list of all base members with a specific attribute. For example, generate a list of members that have the Bottle attribute, and then increase the price for those members. | |
Return the value of the level 0 attribute member that is associated with the base member being calculated. For example, return the numeric value of a size attribute (for example, 12 for the member 12 under Ounces) for the base member being calculated (for example, Cola). For an additional example using @ATTRIBUTEVAL in a formula, see Calculating an Attribute Formula. | |
Convert a date string to numbers for a calculation. For example, use @TODATE in combination with the @ATTRIBUTEVAL function to increase overhead costs for stores opened after a certain date. | |
Generate a list of base dimension members associated with attributes or varying attributes that satisfy the conditions that you specify. For example, generate a list of products that are greater than or equal to 20 ounces, and then increase the price for those products. |