1.
In Solution Explorer (on the
right of the Microsoft Visual Studio window), right-click Data Source Views,
and then click New Data Source View.
2. On the Welcome to the Data Source View Wizard page,
click Next. The Select a Data Source page appears.
3. Under Relational data sources, the Adventure Works DW 2012 data source is selected. Click Next.
4. On the Select Tables and Views page, select tables and views from the list of objects that are available from the selected data source. You can filter this list to help you select tables and views.
In
the Available
objects list, select
the following objects. You can select multiple tables by clicking each while
holding down the CTRL key:
·
DimCustomer (dbo)
·
DimDate (dbo)
·
DimGeography (dbo)
·
DimProduct (dbo)
·
FactInternetSales (dbo)
1.
Click > to add the selected tables to the Included objects list.
2.
Click Next.
3.
In the Name field, make sure Adventure Works
DW 2012 displays, and
then click Finish.
The Adventure Works
DW 2012 data source
view appears in the Data Source Views folder in Solution Explorer. The
content of the data source view is also displayed in Data Source View Designer
in SQL Server Data Tools (SSDT). This designer contains the following elements:
o A Diagram pane
in which the tables and their relationships are represented graphically.
o A Tables pane
in which the tables and their schema elements are displayed in a tree view.
o A Diagram Organizer pane
in which you can create sub diagrams so that you can view subsets of the data
source view.
o A toolbar that is specific to Data Source View
Designer.
4.
To maximize the
Microsoft Visual Studio development environment, click the Maximize button.
5.
To view the tables in the Diagram pane at 50 percent, click the Zoom icon on the Data Source View Designer
toolbar. This will hide the column details of each table.
6.
To hide Solution Explorer, click
the Auto
Hide button, which is
the pushpin icon on the title bar. To view Solution Explorer again, position
your pointer over the Solution Explorer tab along the right side of the
development environment. To unhide Solution Explorer, click the Auto Hide button again.
7.
If the windows are not hidden by
default, click Auto
Hide on the title bar
of the Properties and Solution Explorer windows.
You can now view all the
tables and their relationships in the Diagram pane.
Notice that there are three relationships between the FactInternetSales table
and the DimDate table. Each sale has three dates associated
Key words : SSAS Tutorial, Multidimensional Modeling,CUBE , OLAPBACK TO SSAS TUTORIAL
No comments:
Post a Comment