Database Reference
In-Depth Information
2.
when the Properties Pages dialog window appears, navigate to the Deployment
page, select the Processing options dropdown box (Figure
10-34
), and select Do not
Process.
3.
Verify the server is configured to point to your ssAs server (Figure
10-35
). use
(local), localhost, or your actual computer name; if you are using a named instance,
type in its proper name as well.
4.
Click oK to close the Properties Pages dialog window.
Build Your Project
when the configuration is verified, or reconfigured as needed, it is time for one last build to make sure that
all is ready for deployment.
1.
Build the project one more time and troubleshoot any errors that may occur using
the Error List window (Figure
10-38
).
Tip:
At this point there should not be any errors, because you have been using the Build option to test your
configurations over and over again. If you do find an error and the problem is not apparent, isolate each
dimension to determine which one is giving you the problem by excluding a dimension from the project and
building the project again. If it builds successfully without the excluded dimension, you will know that the
excluded dimension is the source of the issue.
once you determine the problematic dimension, you can add the excluded dimension back into your project
by right-clicking the ssAs project icon and selecting Add Existing Items from the context menu. now you
can focus your attention on the problematic dimension to correct the issue. worst-case scenario: delete the
dimension and remake it again. This sometimes is all it takes to get it working.
Deploy Your Project
with the build successful, we can now deploy or dimensions to the ssAs server.
1.
Deploy the project using Visual studio's Build menu (Figure
10-38
). If you are asked
for a password, please supply the password.
2.
Troubleshoot any errors that may occur using the Error List window (Figure
10-40
).
Refer to the “when Deployment Fails” topic within this chapter for troubleshooting
tips.
3.
Verify that the deployment has succeeded using the Deployment Processes window.
If the window is not showing, you can access this by using the View
➤
show
Deployment Progress menu item, as shown in Figure
10-39
.
Process Your Project
The dimensions are designed, built, and deployed, but they do not have data until they are processed. we will
do that now.
1.
Right-click the PubsBICubes project icon in solution Explorer and select Process
from the context menu, as shown in Figure
10-43
.
