Deploying and Processing Data Mining Objects
We have done a good
bit of work already, having defined a mining structure with several
mining models. We are almost ready to view and query the models, but we
must first deploy and process the SSAS database that contains them. We
can deploy the database and process the mining models in a single step
by choosing the Start Debugging command from the Debug menu, clicking
the Start Debugging (play) toolbar button, or pressing the F5 key.
Deployment and
processing might take several minutes. You can monitor deployment and
processing progress in the Deployment Progress window, which by default
appears as a docked window in the lower-right corner of Visual Studio
when you start the deployment. If the Deployment Progress window is not
visible, you can show it by choosing Show Deployment Progress from the
View menu or by right-clicking the project node and choosing Show
Deployment Progress in Solution Explorer.
It is easiest to monitor
the progress of the deployment and processing of your mining structure
and models by undocking the Deployment Progress window and resizing it
to a relatively large size. Figure 10 shows the Deployment Progress window for a successfully deployed and processed SSAS project.
Tip
The
easiest way to undock the Deployment Progress window is to double-click
its title bar. You can redock it after processing has completed by
double-clicking the title bar a second time. This avoids the sometimes
confusing drag-and-drop procedure for undocking and redocking the
window. |
Caution
If
you encounter processing errors indicating that columns of your data
source do not exist, you might need to change the impersonation
information of the data source in your SSAS project. To do this,
double-click the data source node under the Data Sources node in
Solution Explorer, click the Impersonation Information tab, and select
an appropriate user. During development, you can select the Use The
Service Account option button. Before deploying the database and mining
models to production, however, you should select a specific user account
with the appropriate rights. |
After the initial
deployment of the SSAS database, you can process mining models without
deploying the database. To process all the mining models within a
structure, choose Process Mining Structure and All Models from the
Mining Model menu. To process a single model in a mining structure,
select the model on the Mining Models tab and then choose Process Model
from the Mining Model menu. Both the Process Mining Structure and All
Models command and the Process Model command are also available from
each model’s shortcut menu on the Mining Models tab and from the two
leftmost buttons on that tab’s toolbar.