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

Client
computers

Network Load Balancing

Analysis Server
instances

Replicated data

Master server

FIGURE 25.2 In a distributed application, each server points to a single copy of a database.

measure group from a remote Analysis Services database on demand. You can link dimen-
sions and measure groups from a database on your server, from another instance of
Analysis Services on the same computer, or from Analysis Services running on a remote
server.

Two servers implement the link object. One of the servers, the publisher, stores the data.
The other server, the subscriber, doesn't store data, but requests the data from the
publisher and passes it to the user. To enable the subscriber server to connect to the
publisher server, you have to configure both servers. You also need to make sure that the
user account the subscriber uses to connect to the publisher has sufficient permissions on
the publisher.

Analysis Services supports two modes of linking the metadata of the linked object:
dynamic and static. The differences between these two modes play a role only during the
creation of the object. After you create the linked object, regardless of the mode used, it
behaves in the same way. In the dynamic mode, the subscriber retrieves the metadata of
the linked object from the publisher during creation. To create a linked object in the static
mode, you define the metadata of the linked object as part of the Create command you
send to the subscriber. You could define the metadata as a subset of the metadata defined
on the publisher. For example, you could issue a Create command to the subscriber that