In this step of the wizard, you select a fact table. A fact table contains the numeric data that cube users want to analyze.
The wizard displays a list of data sources that are currently available. Click the “+” to expand the data source and view the tables contained within. If no data source is visible or you want to define one, click New Data Source to define the data source.
Select a primary fact table for the cube from one of the tables in a data source listed under Data sources and tables. When you select a table, its columns appear under Details.
Choose this option to define a new data source. For more information about selecting a data source, click Help in the Data Link Properties dialog box.
Choose this option to preview the contents of the table you have selected.