Listings

Listings

This part of the tutorial demonstrates listings, which display selected records from the lowest-level data for the selected cell or cells. To see how these work, we will first create a pivot table that uses a very small number of records. Then when we display the listing, we will be able to compare it easily to the aggregate value of the cell from which we started.

1. Click New.

2. Drag and drop Patient Count and Avg Test Score to Measures.

3. Expand the AgeD dimension in the Model Contents pane.

4. Expand the Age level.

5. Drag and drop the member 0 to Columns. This member refers to all patients who are less than 1 year old.

   Note that you must click the member name rather than the icon to its left.

   The system displays something like the following:

   

6. Drag and drop the member 1 to Columns, below the member 0.

   The system displays something like the following:

   

7. Expand the BirthTD dimension.

8. Drag and drop the Birth Time level to Rows.

   The system displays something like the following:

   

9. Click a cell. For example, click the Patient Count cell in the 12am row, below 0.

10. Click the Display Listing button .

    The system considers the selected context, which in this case is patients under 1 year old, who were born between midnight and 1 am. The system then executes an SQL query against the source data. This query includes selected fields for these patients, as follows:

    

11. Count the number of rows displayed. This equals the Patient Count value in the row you started from.

12. Click the Display Table button to redisplay the pivot table in its original state.

    By default, the Patients cube uses a listing called Patient details, which includes the fields PatientID, Age, Gender, and others, as you just saw. You can display other listings as well.

13. Click the Pivot Options button to display options for this pivot table.

    The system displays a dialog box.

14. For the Listing drop-down list, click Doctor details and then click OK.

    The Doctor details listing displays information about the primary care physicians for the selected patients.

15. Click the same cell that you clicked earlier and then click the Display Listing button .

    Now the system displays something like the following: