Administering Core Business Intelligence Services - Microsoft SQL Server 2008 R2 Administration - page 144

13. You can use a 'synchronization mechanism' to have your data statically replicated
across all the front-end servers.
Synchronization mechanism: Analysis Services includes a Deployment
Wizard, which is a step-by-step user interface used to perform deployment
tasks. Also, by generating a script method, you can deploy your database
from a test to a production environment using the Synchronize command.
Deployment Wizard: It is a step-by-step user interface used to deploy the
file that results from building an Analysis Services project ( projectname.
asdatabase ) to a target server. You start with an Analysis Services project
developed in BIDS.
14. Let us create a linked dimension and linked measure groups to load data from the
master server, using BIDS.
15. Right-click on the Dimensions node in the Solution Explorer and select New Linked
Dimension to open Linked Object wizard.
16. In the Wizard advance, select Data Source page to create a new data source that
points to the database you want to link your dimension to.
17. Click Finish to complete the wizard. Now, each front-end server checks for
updates and automatically refreshes the data state, if there is any update on
the master server.
18. Now, let us create a process to load and store data on remote servers using the
remote-partitions feature of Analysis Services to distribute data between multiple
back-end servers.
19. On the master server, open the cube's Partitions page. Right-click the cube and
select Partitions.
20. Right-click any partition name and select Delete, then add a new partition by clicking
the New Partition link.
21. Click through the Partition Wizard until you get to the Processing and Storage
Locations page.
22. Under the Processing Location, set Remote AS data source to the newly created
data source that points to your subordinate database. Complete the wizard by clicking
the Finish button.
23. Finally, right-click the cube name in Solution Explorer, select Process and fully
process the cube.
The successful completion of the Cube process will complete the process to deploy a scale-out
implementation of SQL Server Analysis Services on an existing data platform.