Building Scalable Analysis Services Applications - Microsoft SQL Server 2008 Analysis Services - page 461

Master Server Remote Server

FoodMart 2008 RemoteDB

<MasterDataSourceID>Master
DS</MasterDataSourceID>

RemoteDS

MasterDS

Inventory
Fact 1997

FIGURE 25.5

The partition Inventory Fact 1997 is a remote partition.

<DatabaseID>Remote DB</DatabaseID>
</ParentObject>
<ObjectDefinition>
<DataSource xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=

”http://www.w3.org/2001/XMLSchema-instance” xsi:type=”RelationalDataSource”>
<ID>MasterDS</ID>
<Name>MasterDS</Name>
<ConnectionString>Provider=MSOLAP.4;Data Source=localhost;Integrated

➥

Security=SSPI;Initial Catalog=FoodMart 2008</ConnectionString>
<ImpersonationInfo>
<ImpersonationMode>ImpersonateServiceAccount

➥

</ImpersonationMode>
</ImpersonationInfo>
</DataSource>
</ObjectDefinition>
</Create>

➥

3. Change the MasterDataSourceID property of the Remote DB database to point to the
newly created MasterDS data source object. You can do this by submitting the Alter
command shown in Listing 25.5.

LISTING 25.5

DDL to Alter a Database to Add MasterDataSourceID

<Alter AllowCreate=”true” ObjectExpansion=”ObjectProperties”
➥

xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
<Object>
<DatabaseID>Remote DB</DatabaseID>
</Object>
<ObjectDefinition>
<Database xmlns:xsd=”http://www.w3.org/2001/XMLSchema”

xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>

➥