Before generating cubes, you must define a data source with an OLE DB connection that will specify from where the cubes will be populated.
Procedure
- 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.
Results
When you have created the appropriate data sources, you can proceed with generating your cubes.