XY (Scatter) Chart for Analysis Services Data - Page 5
September 29, 2009
1. Click the Data tab.
2. Using the downward pointing arrow on the right side of the Dataset name box atop the Data tab, display and select the ProductData dataset, as shown in Illustration 17.
3. Click the Add... button to the right of the Values list box, found immediately underneath the Dataset name selector we populated above.
The values in a value series determine the position of each data point in the chart. There are two values for each value series: X and Y. These two values are required. The value of X determines the position of the data point on the x-axis. The value of Y determines the position of the data point on the y-axis. If the chart contains multiple value series, the chart displays multiple series in the chart and in the chart legend.
The Edit Chart Value dialog appears, defaulted to the Values tab.
4. Type the following into the Series label box, atop the Values tab:
5. Click the function (fx) button to the right of the box labeled X, depicted within a circle in Illustration 18.
The Expression Editor opens.
6. Click the Fields (ProductData) option in the bottom left corner pane of the Expression Editor.
The field values of the ProductData dataset appear within the pane to the bottom right of the Expression Editor.
7. Double-click Month to place this selection into the main pane atop the Expression Editor.
The Expression Editor appears, with our input, as shown in Illustration 19.
8. Click OK to accept our input and to dismiss the Expression Editor.
9. Click the downward pointing arrow on the right side of the combination box labeled Y, immediately below the box labeled X.
10. Select =SUM(Fields!Internet_Sales_Amount.Value) from the options that appear.
The Edit Chart Value dialog appears with our input as depicted in Illustration 20.
11. Click the Appearance tab on the Edit Chart Value dialog.
12. Click the Series Style... button in the lower left corner of the Appearance tab.
The dual tabbed Style Properties dialog appears again, just as it did for the Chart Area Style... and Plot Area Style... buttons we examined earlier. We see the same Border and Line and Fill tabs, which we will leave at default at this point.
13. Click OK to dismiss the Style Properties dialog, and to return to the Appearance tab of the Edit Chart Value dialog.
14. Click the Point Labels tab on the Edit Chart Value dialog.
15. Ensure that the check box to the immediate left of Show point labels, atop the Point Labels tab, is unchecked.
The Point Labels tab of the Edit Chart Value dialog box appears as shown in Illustration 21.
16. Click the Action tab of the Edit Chart Value dialog.
Here we can define Hyperlink actions, including Jump to report, Jump to bookmark, or Jump to URL. We will not be working with a drillthrough scenario in this practice session, and so will leave undisturbed the default setting of None, as depicted in Illustration 22.
17. Click the Data Output tab of the Edit Chart Value dialog.
The Data Output tab affords us a means of defining XML data output options for the values in the chart. We will not leverage these capabilities within this introduction to Line charts, and will therefore leave the settings of the Data Output tab at their defaults, as shown in Illustration 23.
18. Click the OK button at the bottom of the Edit Chart Value dialog, to dismiss the dialog with our settings.
We are returned to the Data tab of the Chart Properties dialog. Next we will work with the Category groups area of the tab, just under the Values area. Categories are displayed as data points within a series group. (A typical XY chart contains non-aggregate expressions for values. The expression for X in the value chart area and the expression for the Category group are also typically the same.)
19. Click the Add... button to the right of the Category groups list box, found immediately underneath the Values list box with which we worked above.
The Grouping and Sorting Properties dialog appears, defaulted to the General tab.
20. Type (or cut and paste) the following into the Name box, atop the General tab:
21. Click the top row of the Expression box within the Group on section that appears just underneath the Name box, to enable the selector button (the downward-pointing arrow) on the right side of the box.
22. Select =Fields!Month.Value from the options that appear, as depicted in Illustration 24.
23. Select =Fields!Month.Value in the Label box, just below Expression box within the Group on section.
As we have no input for the Filters or Data Output tabs (which resemble their counterparts in other areas of the Report Designer, as we have, and shall, see), within the context of this newly added group, and as we intend to leave the Sorting at the settings naturally found within the cube structure, we will accept our input at this stage.
The Grouping and Sorting Properties dialog (General tab) appears, with our modifications, as shown in Illustration 25.
24. Click the OK button at the bottom of the Grouping and Sorting Properties dialog, to save our settings and to dismiss the dialog.
We return to the Data tab, once again, which appears, with our Values and Category groups settings, as depicted in Illustration 26.
We will move to the X Axis tab in the subsection that follows.