Linked Cube Dialog Box
Use this dialog box to create a linked cube. A linked cube is based on another cube, called a source cube, which is defined and stored on another Analysis server. You can create linked cubes as an alternative to storing multiple copies of a cube on multiple Analysis servers. For more information about linked cubes, see Linked Cubes.
To create a linked cube, you must have access to the source cube. You have access if your user name is included in either of the following on the Analysis server where the source cube is defined: the OLAP Administrators group or a cube role for the source cube.
This dialog box appears when, in the Analysis Manager tree pane, you right-click a Cubes folder and then click New Linked Cube.
Options
Name
Type a name for the linked cube. The name must begin with an alphabetical character and can be up to 50 characters in length.
Source Cube
Expand a data source and select the source cube.
Important Do not select from a data source that has the same Analysis server as the Analysis server on which you are creating the linked cube.
Cubes are displayed only if they have been processed since they were last changed.
You can refresh the connection to a data source by right-clicking the data source and then clicking Refresh Connection.
Dimensions
View the dimensions contained in the cube selected in the Source Cube box. The Dimensions box is read-only.
New Data Source
Click to display the Multidimensional Data Source dialog box, where you can specify a new multidimensional data source. For more information about this procedure, see Managing Linked Cubes.
Process after creating new cube
Select to begin processing the new linked cube when you click OK.
To process a linked cube on an Analysis server, the Analysis server service (MSSQLServerOLAPService) logon account must be a domain user account. This account must have access to the source cube. The account has access if it is included in either of the following on the publishing server: the OLAP Administrators group or a cube role for the source cube. If the account does not have access to the source cube, computers or users cannot process the linked cube through that account.