The Advanced Settings dialog appears as shown in Illustration 33, with the syntax we have added.

Illustration 33: Our Filter Statement in the Advanced Settings Dialog

Now let's set up a drillthrough capability that will help us quickly evaluate the effectiveness of our efforts in the Verification section that follows.

22. Click the Drillthrough Options button in the bottom section of the Advanced Settings dialog.

The Partition Drillthrough Options dialog opens.

23. Within the selection checklist, ensure that only the checkboxes presented in Table 1 below are checked:

Column

Table

"product_id"

"sales"fact_1997"

"customer_id"

"sales"fact_1997"

"store_sales"

"sales"fact_1997"

"the_date"

"time_by_day"

Table 1: Select Settings for the Detail Drillthrough View ...

Our intent here is simply to establish the display of dated transactions  to give us a feel that transactions within reasonable date ranges are, indeed, underneath the totals we see in the age buckets. The columns selected here could obviously be varied to accomplish other specific needs just as easily.

The Partition Drillthrough Options dialog (partial view of the selection checklist) appears as depicted in Illustration 34, with the syntax we have added.

Illustration 34: Partial View of the Selection Checklist

24. Click OK to accept changes and close the Partition Drillthrough Options dialog.

25. Click OK once again, this time to accept and close the Advanced Settings dialog with our input.

26. Click the Finish button on the Finish the Partition Wizard page, to which we return next.