You can perform specific calculations on attribute-dimension members in a database. See Calculating Attribute Data.
For example, to calculate profitability by ounce for products sized in ounces, you can use the @ATTRIBUTEVAL function in a calculation formula. In the Sample.Basic database, the Ratios branch of the Measures dimension contains a member called Profit per Ounce. The formula on this member:
Profit/@ATTRIBUTEVAL(@NAME(Ounces));
Essbase cycles through the Products dimension, performing the following calculations:
See Using Attributes in Calculation Formulas. For more information about the @ATTRIBUTEVAL function, see the Oracle Essbase Technical Reference. |