You can set the format for attribute calculation member names, but an attribute calculation member name cannot be the same as a member name.
For information on attribute calculations, see Attribute Calculations Overview
To set the format for attribute calculations member names in an Essbase model:
Access the Essbase Model Properties dialog box using the procedure in Accessing the Essbase Model Properties Dialog Box.
Optional: In the Dimension text box, rename the Attribute Calculations Dimension.
Optional: In the Sum member text box, rename the Sum member.
For example, Sum can be renamed Total.
This attribute sums members based on their consolidation property or formula. Sum calculates a sum, but it does not always calculate a simple sum. Sum totals members based on their consolidation property or formula. For example, you can Sum the Profit% for 12-Ounce drinks, and the Sum will be based on the Profit% formula, which is profit divided by sales, with the resulting ratio multiplied by 100.
Optional: In the Count member text box, rename the Count member .
This attribute calculates the number of members with the specified attribute or combination of attributes. Count includes only those members that have data blocks in existence.
Optional: In the Minimum member text box, rename the Minimum member .
This attribute calculates the minimum data value for a specified attribute or combination of attributes.
Optional: In the Maximum member text box, rename the Maximum member .
This attribute calculates the maximum data value for a specified attribute or combination of attributes.
Optional: In the Average member text box, rename the Average member .
This attribute calculates a mechanical mean (average) of the values for a specified attribute or combination of attributes. The average includes only those members that have data blocks in existence (sum divided by count).
Note: | To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default. |
Attribute calculations have the following properties:
System-defined: When you create an attribute dimension in an outline, the resulting reports and spreadsheets have five predefined calculations available for all attribute members.
Dynamic Calc: All attribute calculations are calculated when a user requests the calculation, and then the calculation is discarded. You cannot store the calculated data in a database.
Displayed in Reports: Attribute calculation results are not displayed in the outline. The calculation results are available only in spreadsheets and reports.