following into the Restore database box immediately above the Storage location
box in the Restore Target section:
The Restore Database
dialog, with our input, appears as shown in Illustration 7.
Illustration 7: The Completed Restore Database Dialog
Click OK to
initiate the restoration.
The Restore Database dialog
grays, as the Executing symbol in the Progress pane, once again, becomes
active. The process runs, and, once completed, the dialog closes, returning us
to the Management Studio.
Within the Object
Explorer, right-click the Databases folder underneath the Analysis Server name,
from the context menu that appears, as depicted in Illustration 8.
Illustration 8: Right-click the Databases Folder Select Refresh ...
We see the new ANSYS087_AS
database appear in the Object Browser, as shown in Illustration 9.
Illustration 9: The New Database Appears ...
the preceding steps, we are now ready to access the new Analysis Services
database we have created within the SQL Server Management Studio. Here, we are
positioned to take a look at some of the options available for resource
assignment and partition settings, which we will examine as a part of our
discussion surrounding partition planning.
Note: We examined similar options available for resource assignment and partition settings from
a Business Intelligence Development Studio perspective in Cube
Storage: Planning Partitions (Business Intelligence Development Studio
as mentioned above. To see similar settings to those we examine below in Business Intelligence Development
Studio, please see
at this point, upon the Adventure Works cube, within the clone Analysis
Services database we have created, and begin setting ourselves up for our
review in the next section with the following steps:
In the Object
Explorer of the Management Studio, once again, expand the ANSYS087_AS database
that we created earlier by clicking the + sign to its
manner, expand the Cubes folder that appears underneath the newly expanded
Folders for the two cubes
in the sample database, Adventure Works and Mined Customers (a data mining
cube) appear, as depicted in Illustration 10.
Illustration 10: The Folders for the Cubes of Our New Analysis Services Database Appear ...
Expand the Adventure
The Measure Groups folder for the Adventure Works cube
next appears. We recall that partitions, at least within our present context,
are associated with measure groups. Hence it is easy to see why partition settings
and properties are located where they are.
Expand the Measure
The individual Measure
Groups for the cube next appear, as shown in Illustration 11.
Illustration 11: The Measure Groups for the Adventure Works Cube Appear ...
Expand the Internet
Sales Measure Group, by clicking the + sign to its
The Partitions, Writeback,
and Aggregation Design folders appear, as depicted in Illustration 12.
Illustration 12: The Partition, Writeback, and Aggregation Design Folders Appear ...
For purposes of this article,
we will be working within the folders that appear above (most predominantly
within the Partitions folder), where partitions can be conveniently constructed
and maintained. Here we can perform settings and assignments related to storage,
proactive caching, writeback, and more for each measure group within the cube,
as we shall see.
We are now positioned to begin our discussion of partition
planning, and our examination of some of the resource assignments and settings upon
which our partition planning efforts can be based.