The All Members

The All Members

An All member refers to all records of the base class. Each dimension can have an All member, but in the Patients cube, only one dimension has an All member.

This part of the tutorial demonstrates how you can use an All member:

1. Click New.

2. Expand the AgeD dimension.

3. Drag and drop Age Group to Rows.

4. Drag and drop the measures Patient Count, Avg Age, and Avg Test Score to Measures. The system displays something like the following:

   

5. Click the Pivot Options button .

6. In the Row Options area, click the Summary check box, leave Sum selected in the drop-down list, and then click OK.

   The system then displays a Total line, as follows:

   

   The Total value is appropriate for Patient Count but not for the other measures. For Avg Age and Avg Test Score, it would be more appropriate to display an average value rather than a sum.

7. Click the Pivot Options button again.

8. In the Row Options area, clear the Summary check box and then click OK.

9. Drag and drop All Patients to Rows, below Age Group. The system then displays the All Patients after the members of the Age Group level:

   

   The All Patients row is a more useful summary line than the Total line. It shows the Patient Count, Avg Age, and Avg Test Score measures, each aggregated across all patients.

   Note:

   For Avg Age and Avg Test Score, in some cases, you might prefer to have an average of the values shown in the pivot table. For example, for Avg Age, this summary line adds the ages of all patients and then divides by 10000. You might prefer to add the values of Avg Age for the three members shown here and then divide that by three. The All member does not help you do this; instead you would create a calculated member (discussed later in this tutorial).

10. Click the X button in the Rows pane. This action clears the row definition.

11. Expand the DiagD dimension.

12. Drag and drop Diagnoses to the Rows pane.

13. Drag and drop AgeD > All Patients member to Rows, below Diagnoses. You then see something like the following:

    

    As you can see, you can use the generically named All Patient member with dimensions other than Age, the dimension in which it happens to be defined.