Linked cubes are built using the Linked Cube dialog box. This dialog box allows you to specify a source cube for a new linked cube on a publishing server. The source cube can be based on any data source that the current user has permissions on.
To build a new linked cube
To select a source cube for the new linked cube, select a cube from the list of cubes in the source cube pane.
Important If source cubes reference user-defined functions that are contained in DLLs on the publishing server, the DLLs need to be registered on the linked cube's subscribing server so that the user-defined functions can be referenced by the linked cube. Also, if a source cube has members with custom member formulas or custom rollup formulas that reference other cubes on the publishing server, then the cube that is referenced on the publishing server must be referenced on the subscribing server. You can make the reference on the subscribing server by creating another linked cube that is based on the cube being referenced in the formulas. This linked cube must have the same name on the subscribing server as the source cube on the publishing server.
To specify a data source for a linked cube
If the source cube is a member of a data source that is not listed in the Source Cube box, you can add a new data source with the Multidimensional Data Source dialog box. After you select a cube, you can give it a name in the Name box. A list of the dimensions of the cube is displayed in the Dimensions box. Before creating the linked cube, you must decide whether or not to process the new linked cube immediately after creating it. If you want to process the cube immediately, you must select the Process after creating new cube check box.
The Multidimensional Data Source dialog box is used to add a new data source to the database. The name field specifies the name of server on which the new data source resides. The Database list specifies a database on that server. You can test your connection settings to the server by clicking Test Connection.
Clicking Advanced opens the Data Link Properties dialog box. Use this dialog box to specify a data source when you want to use nondefault options and properties for connection to the data source. For example, if the logon account for the remote server is different from the current account, use this dialog box to specify a different user name and password. You can also set other connection properties by using the Advanced and All tabs of the dialog box.
After the new cube is created, it must be processed before it can be browsed by a client application.
To process a linked cube
For more information, see Linked Cube Dialog Box.