Working with Data Sources and Data Source Views - Professional SQL Server Analysis Services 2005 with MDX - page 159

his manager, you might want to establish a relationship so that your
model can take advantage of this.
In addition, a sample of data from the tables in the DSV helps you in identify-
ing the measures of the cube as well as the hierarchies of each dimension.
Analyzing sample data in DSV also helps you to identify dimensions that can
be created from the fact table data. The analysis of sample data within the
DSV is even more important in creating your Data Mining models. You learn
more about analyzing the data with respect to Data Mining in Chapter 13 .
To see a sample of the data you need, right-click a table in the DSV and se-
lect Explore Data. You can now see rows from the underlying table presented
within the Explore <tablename> Table window as shown in Figure 4-20 . The
data presented is only a subset of the underlying table. By default the first
5,000 rows are retrieved and shown within this window. You can change the
number of rows retrieved by clicking the Sampling Options button. Clicking
the Sampling Options button launches the Data Exploration options where
you can change the sampling method, sample count, and number of states
per chart which is used for displaying data in the chart format. Once you have
changed the sample count value you can click the Resample Data button to
retrieve data based on the new settings. The Explore Table window has four
tabs: Table, Pivot Table, Chart, and Pivot Chart. The Table tab shows the raw
sampled data from the data source as rows and columns with column head-
ings.