Database Reference
In-Depth Information
mensions and measure groups even if you create a cube-based on existing
tables, so the empty cube option isn't particularly useful. Generating tables
in the data source option allows you to use one of the built-in templates to
create the sample Adventure Works SQL Server database tables.
4. For this exercise let's choose
Use existing tables
and click on
Next
, as
shown in the following screenshot:
5. The following screen allows you to choose the data source and the fact
table(s) to be included in the cube. Since the project only contains one data
source view, the wizard automatically uses it by default. Notice the
Suggest
button: if you click on this button, SSDT will recommend tables that could
be used as measure group sources. Since measures are normally numeric,
SSDT will suggest using tables that contain numeric columns. If you choose
Search WWH ::
Custom Search