Aggregate Weights

 

Specify Member Weight

Aggregate weights are used when a Member must be assigned a multiplied value in an aggregation in order for the data to be properly represented. For example, in the Accounts hierarchy, Cost of Salesshould be handled as a negative number in the Gross Profit aggregation because it will represent an amount subtracted from Gross Profit (i.e., style=”font-style: italic;”>Gross Profit = Net Sales – Cost of Sales). To designate Cost of Sales as a negative number in the Gross Profit aggregation, we can assign it a weight of “–1”. This means that the data included in Cost of Sales will always be multiplied by –1 when it is rolled up in the Hierarchy.

 

To “weight” Cost of Sales, complete the following process:

1.   Return to ‘Accounts’ Hierarchy dialog box (double-click on Accounts in the Dimensions dialog box), and double-click Cost of Sales in the Hierarchy Definition box on the right.

Note that, to the right of Cost of Sales, a box appears where “1” is highlighted and where you can enter a weight for the Member.

2.   Enter -1 in the box so that it appears as follows:

3.   Click the OK button  on the toolbar when complete.
You are returned to the Dimensions dialog box.

4.   Click OK.
You are returned to the main application window.

 Notes

In PowerOLAP®, the default Aggregate weight is equal to ‘1’. Thus, a parent Aggregate member is simply the sum of all Child members defined in the Dimension hierarchy. In the example exercise, all Aggregates you defined are standard with the exception of Gross Profit, in the Accountsdimension. Therefore, you do not need to define Aggregate weights for the remaining Aggregate members.