Analysis Services
Select a Fact Table (Cube Wizard)
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 expand (+) button to expand the data source and view the tables contained within.
Options
Data sources and tables
Select a primary fact table for the cube from one of the tables in a data source listed in this box.
Details
View the columns in the table selected in the Data sources and tables box.
New Data Source
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.
Browse Data
Choose this option to preview the contents of the table you have selected.