We now have to perform a set of steps that allow us to work with
the Warehouse cube in its currently partitioned state. As I
mentioned earlier, we might have merged the partitions, or "started out
fresh" otherwise, but taking the following steps to re-align the new views
to the partitions represented a quick approach to preparing to work within the Warehouse
cube structure, while minimizing rework.
In addition to handling the aforementioned eccentricities, we also
get practice at a couple of things that might be useful to us in a real world
scenario. Keep in mind that this "re-alignment" step for the
partitions will not likely be a common requirement in most scenarios, as I
stated earlier, as final partitioning, if enacted, would likely come
after major cube design work was done. Even if partitioning was in place, we
would likely merge to a single source, make our design changes, and then
re-partition based upon the new design (which might change the overall
partitioning strategy anyway).
9. Expand the Warehouse
cube within the Relative Time Sample database, by clicking the "+"
to its immediate left.
10. Expand the Partitions
folder that appears immediately underneath the expanded cube.
11. Right-click the Warehouse
(the uppermost) partition.
12. Select Edit from
the context menu that appears, as depicted in Illustration 32.
Illustration 32: Select
Edit to Re-align the Partition
The Partition Wizard: Warehouse dialog appears.
13. Click the Change
button.
The Choose a fact table dialog appears.
14. Scroll to the bottom
of the Tables pane, and select vW_inventory_fact_1997, one of the
views we created in MS Access as part of our preparation for this exercise, as
shown in Illustration 33.
Illustration 33: Select
Edit to Re-align the Partition
15. Click OK to
accept the choice.
We are returned to the Partition Wizard: Warehouse dialog, which now
appears as depicted in Illustration 34.
Illustration 34: Re-aligning
the Partition
16. Click Next to
move to the Select the data slice dialog.
17. Click the Time
dimension, in the Dimensions box, to select it.
18. Click 1997 in
the Members box, to select it.
The Select the data slice dialog, with our selections, appears as shown
in Illustration 35.
Illustration 35: Select
the Data Slice Dialog, with Our Selections
19. Click Next.
20. Click Next at
the Specify the partition type dialog, which is fixed with regard to the
Local setting, anyway, as depicted in Illustration 36.
Illustration 36: Specify
Partition Type – Fixed as Local
We arrive at the Finish the Partition wizard dialog.
21. Leaving the setting of
Use the current set of aggregations in place, put a check in the
checkbox to the left of the Process the partition when finished entry
(bottom of the dialog).
The Finish the Partition wizard dialog, with our settings, appears as shown
in Illustration 37.
Illustration 37: Finish
the Partition Wizard Dialog
22. Click Finish.
23. Click Yes on
the warning message box that appears, as depicted in Illustration 38.
Illustration 38: Click
Yes to the Warning ...
Processing
begins immediately, is it did in earlier processing evolutions, and the Process
viewer once again displays various logged events. The Processing completed
successfully message appears, as before, upon processing completion, as
depicted in Illustration
39.
Illustration 39:
Indication of Successful Processing Appears (Compact View)
24.
Click Close
to dismiss the viewer.
We return
to Analysis Manager. We will now repeat
the steps for re-pointing the partition for the second entry in the Partitions
folder, Warehouse 98.
25.
Right-click
the Warehouse 98 partition.
26.
Select Edit
from the context menu that appears.
The Partition
Wizard: Warehouse dialog appears.
27.
Click the Change
button.
The Choose
a fact table dialog appears.
28.
Scroll to the
bottom of the Tables pane, and select vW_inventory_fact_1998, the
second of the views we created in MS Access as part of our preparation for this
exercise.
29.
Click OK
to accept the choice.
We are
returned to the Partition
Wizard: Warehouse
dialog, which now appears as shown in Illustration 40.
Illustration 40:
Re-aligning the Partition
30.
Click Next
to move to the Select the data slice dialog.
31.
Click the Time
dimension, in the Dimensions box, to select it.
32.
Click 1998 in
the Members box, to select it.
33.
Click Next.
34.
Click Next
at the Specify the partition type dialog, which is, again, fixed with
regard to the Local setting.
We arrive
at the Finish the Partition wizard dialog.
35.
Leaving the
setting of Use the current set of aggregations in place, once again, put
a check in the checkbox to the left of the Process the partition when
finished entry (bottom of the dialog).
36.
Click Finish.
37.
Click Yes
on the warning message box that appears, as we did with the first partition
above.
Processing
begins immediately, as before, and the Process viewer once again
displays various logged events. The Processing completed successfully
message appears, as within our earlier processing evolutions, upon completion.
38.
Click Close
to dismiss the viewer.
We return
to Analysis Manager. We are now ready to create the structure that will support
Relative Time aggregations within our Warehouse cube.
IE 7
Firefox 2.0