Database Reference
In-Depth Information
6. Close this window.
7. Right-click on the
Product Category
tab and delete it from the model.
8. Now, import the
Product Category
and
Subcategory
tables separately and
then use a calculated column to serve the same purpose as the table you
just deleted.
9. On the
Analysis Services
toolbar, the third icon is
Existing Connections
.
Click on this icon to open the
Existing Connections
dialog.
The connection on this list was created when you initially imported tables into
the model from SQL Server.
10. On the
Existing Connections
dialog window, click on
Open
to select more
tables and data to import. The
Table Import Wizard
opens.
Search WWH ::
Custom Search