Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II - Page 8

July 11, 2005

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.








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers