Dimension Design - Professional SQL Server Analysis Services 2005 with MDX - page 186

<AxisFormat>ClusterFormat</AxisFormat>
</PropertyList>
</Properties>
</Execute>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
In the above XML/A, a request is sent to execute an MDX query that is speci-
fied within the command Statement on the catalog AnalysisSer-
vices2005Tutorial. The XML request shown above results in the query being
executed on the server side and the results sent to the client side via XML/A.
Several commands are used to communicate to Analysis Server 2005. Some
of the common commands are Create, Alter, Process, and Statement. These
commands are used to change the structure of objects described. Each ob-
ject in Analysis Services 2005 has a well-defined set of properties. The com-
plete definition of the objects is referred to as Data Definition Language in this
book. You will learn some of the DML and DDLs used in Analysis Services
2005 in various chapters of the topic through examples. For in depth under-
standing of DMLs and DDLs we recommend you to read the Analysis Ser-
vices 2005 documentation.
You might recall that you deployed the Analysis Services 2005 tutorial project
in Chapter 2 . What actually happens when you deploy a project is that the
BIDS packages all the design change information in the project as a single
XML/A request and sends it as a whole. In this case, you want to see the con-
tents of the dimension you have created. Therefore you need to deploy the
project to an instance of Analysis Services. Deploy the project to your Analys-
is Services instance by right clicking on the solution AnalysisSer-
vices2005Tutorial and selecting Deploy or using the F5 function key. When
you deploy the entire project using BIDS to Analysis Services, several XML/A
requests are sent by BIDS. They are:
1. Request for a list of the databases from Analysis Services to determ-
ine if the current project already exists on the instance. The project
name you specified while creating the object will be used as the
database name. Based on the deployment settings in your project,
BIDS either sends the entire definition of all the objects or only the
changes you have made since the last deploy. The BIDS will either
use a Create or Alter statement based upon the fact the database