Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 113 of 212

101 C H A P T E R 6 | More analytics the copy of the partition (which has the prefix Sample). Click the Edit SQL Query button to add a WHERE clause to the partition query, as shown in Figure 6-2, which returns a subset of the original partition query. When you close the Partition Manager and process the partition, the subset of rows defined by your query is displayed in the model designer. Figure 6-2: Configuring sample data for a partition in DirectQuery mode. Note If you create multiple sample partitions, the model designer displays the combined results from all the queries. Notice the Set As DirectQuery button below the list of partitions in Figure 6-2. This button appears only when you select a sample partition in the list. When you click this button, you reset the partition that Analysis Services uses to retrieve data for user queries. For this reason, there can be only one DirectQuery partition defined for a table at any time. If you select the DirectQuery button, the button's caption displays Set As Sample instead. You can also use a sample data partition with the Analyze Table In Excel feature to test the model from the presentation layer. It's helpful to test the results of calculations in measures and to check relationships between tables even when you are using only a subset of data. To do this, select Analyze In Excel from the Model menu. When the model is in DirectQuery mode, the Analyze In Excel dialog box requires you to choose one of two options, Sample Data View or Full Data View, as shown in Figure 6-3.

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016