Performing Ad Hoc Analysis

Displaying the Default Detail Listing

To display the default detail listing:

1. Display a pivot table as usual.

2. Click the data cells in the row or rows.

   To select multiple cells, hold the Shift key down while clicking the cells.

   To select an entire row, click the row label on the left. To click an entire column, click the column header.

   The listing option is not available for cells in a total row or a total column.

3. Click the Listing button .

The Pivot Preview area displays something like the following:

If there are more than 100 rows, the bottom area displays buttons that you can use to page through all the rows.

The Pivot Builder area now displays the Custom Listing Fields box, which is for use when you select fields to display, if possible.

Displaying a Different Detail Listing

To display a different listing:

1. Display the default listing as described earlier.

2. Select Detail Listings in the Model Contents area.

3. Click the name of the listing to display.

   Typically each listing uses a different set of fields and is meant for a different purpose.

   If the name of a listing is italicized, that indicates that this listing is defined in a listing group and that you have the necessary permissions to modify the listing. See “Defining Listing Groups” in Defining DeepSee Models.

Or, before you display the listing, do the following:

1. Click the Pivot Options button .

2. Select a listing from the Listing drop-down menu.

3. Click OK.

Creating a Custom Listing

Depending on the subject area, you might be able to create a custom listing that uses fields that you select. To do so:

1. Display the default listing as described earlier.

2. Select Detail Listings in the Model Contents area.

3. Select Custom Listing.

   DeepSee then displays a listing that initially shows only the IDs of the records.

4. Optionally clear the Auto-execute check box.

   This is helpful if the listing uses many records, because each time when you change the listing definition, DeepSee reruns the corresponding query by default. When Auto-execute is off, DeepSee does not rerun the query automatically.

5. Expand the Custom Listing folder. For example:

   

   This folder lists the available listing fields in this subject area.

   Note that the Patients cube in SAMPLES defines a listing named Custom listing. This listing is an ordinary listing defined with custom syntax and cannot be used as described here.

6. Drag listing fields from this area to the Custom Listing Fields box.

7. If you cleared the Auto-execute check box, use the Refresh button in the Pivot Builder area.

   DeepSee then runs the query and displays the results. For example:

   

Sorting a Listing

By default, the definition of a listing controls the order of the rows.

You can instead sort the listing by the values shown in any data column. To do so, double-click the column header.

The first time you double-click the column header, the listing is sorted in ascending order, by the values in that column, and the column header includes the >> characters to indicate this sorting.

If you double-click the column header again, the listing is sorted in descending order instead (and the column header includes the << characters). If you double-click a third time, the sorting is removed and the default order is restored.

Exiting the Listing

To exit the listing and redisplay the pivot table, do either of the following:

• Click the left arrow button

• Click the Display Table button:

Drilldown in a Hierarchy

This section describes drilldown in a hierarchy. For example, in the Patients sample, The ZIP code level is the parent of the city level. Consider the following pivot table:

If you double-click the cell 38928, the system displays the following in the upper right of the pivot builder area:

And the pivot table looks like this:

Custom Double-Click Drilldown

To customize how DeepSee drills down, see “Customizing Double-Click Drilldown” earlier in this book. This section provides a demonstration.

For example, consider the following pivot table:

Suppose that for this pivot table, we specify Drilldown Expression as follows:

colord.h1.[favorite color].members
gend.h1.gender.members

If we double-click the cell 32006, the pivot table then looks like this:

If we double-click the cell None, the pivot table then looks like this:

If we double-click again, nothing further happens.

Saving the Drilldown

If you drill down in a pivot table and then save it, the Analyzer saves its drilldown state. That is, when you next open it, the Analyzer redisplays the pivot table with the drilldown. Similarly, if the pivot table is included in any dashboards, they display it in its drilldown state.

Clearing the Drilldown

To clear the drilldown of a pivot table, you can do any of the following:

• Click the left arrow button in the toolbar.

• Click the X button in the Drill down area in the toolbar, if applicable.

• Click the << arrows in any of the rows in the pivot table.