Viewing an Attribute Calculation Example

As an example of how Essbase calculates attribute data, consider the following yearly sales data for the East:

Table 24. Sample Attribute Data

Base-Dimension Member

Associated Attributes

Sales Value for Attribute-Member Combination

Cola

Ounces_12, Can

23205

Diet Cola

Ounces_12, Can

3068

Diet Cream

Ounces_12, Can

1074

Grape

Ounces_32, Bottle

6398

Orange

Ounces_32, Bottle

3183

Strawberry

Ounces_32, Bottle

5664

Figure 45, Sample Spreadsheet with Attribute Data shows how calculated attribute data might look in a spreadsheet report. You can retrieve multiple Attribute Calculations members for attributes. For example, you can calculate Sum, Count, Avg, Min, and Max for bottles and cans.

Figure 45. Sample Spreadsheet with Attribute Data

This image shows a sample spreadsheet based on the sample attribute data provided in table above the image.