You specify a data source for a cube as follows:
-
Create a data source in your PDM from the List of data sources or by right-clicking the model in the browser and selecting from the contextual menu.
-
Select the OLE DB tab and specify the kind of data provider.

-
Click the ellipsis tool to the right of the connection string field to open the provider-specific configuration dialog.

-
Complete the parameters appropriately, click Apply to Connection String, and then Test Connection. Then click Ok to return to the data source property sheet.
-
Click OK to return to your model.
When you have created the appropriate data sources, you can proceed with generating your cubes.