Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Mar 2, 2009

A More Advanced Pie Chart for Analysis Services Data - Page 5

By William Pearson

Data Tab

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.

Select the ProductData Dataset ...
Illustration 17: Select the ProductData Dataset ...

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 size of the slice in the pie. Multiple Value series appear as separate slices. Settings for the x- and y-axis are ignored for Pie charts, as we shall see. If we have multiple Category or Series groups, the group labels are displayed 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:

Internet Sales

5.  Click the function (fx) button to the right of the Value box, depicted within a circle in Illustration 18.

Click the Function Button for the Value Box ...
Illustration 18: Click the Function Button for the Value Box ...

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 at the bottom right of the Expression Editor.

7.  Double-click Internet_Sales_Amount to place this selection into the main pane atop the Expression Editor.

The Expression Editor appears, with our input, as shown in Illustration 19.

The Expression Editor with Our Input ...
Illustration 19: The Expression Editor with Our Input ...

8.  Click OK to accept our input and to dismiss the Expression Editor.

We are returned to the Edit Chart Value dialog, which appears with our input as depicted in Illustration 20.

The Edit Chart Value Dialog, with Our Input...
Illustration 20: The Edit Chart Value Dialog, with Our Input...

9.  Click the Appearance tab on the Edit Chart Value dialog.

10.  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.

11.  Click OK to dismiss the Style Properties dialog, and to return to the Appearance tab of the Edit Chart Value dialog.

12.  Click the Point Labels tab on the Edit Chart Value dialog.

13.  Click the check box to the immediate left of Show point labels atop the Point Labels tab, to place a check mark within the box.

14.  Click the downward pointing arrow to the right of the Data label box to display data selection options.

15.  Select =Fields!Internet_Sales_Amount.Value from the options, as shown in Illustration 21.

Select =Fields!Internet_Sales_Amount.Value as the Data Label ...
Illustration 21: Select =Fields!Internet_Sales_Amount.Value as the Data Label ...

16.  Within the Format code box (just underneath the Data label selector) type the following character pattern:

#,###

This will result in the point labels being displayed within the slices of the Pie (when accommodated by slice size), making the chart more compact and, in this case, making the labels themselves somewhat easier to visually associate with their respective slices.

17.  Click the Label Style ... button immediately underneath the Angle setting.

The Style Properties dialog box appears.

18.  Make the settings, listed in Table 2 below, within the Style Properties dialog box:

Property

Setting

Family

Arial

Size

8pt

Style

Normal

Weight

Normal

Color

Red

Decoration

None


Table 2: Style Properties Dialog

The Style Properties dialog appears, with our settings, as depicted in Illustration 22.

Style Properties Dialog Box with Settings
Illustration 22: Style Properties Dialog Box with Settings

19.  Click OK to accept settings.

The Style Properties box closes. We return to the Edit Chart Value dialog box, which now appears as shown in Illustration 23.

The Edit Chart Value Dialog Box, with Our Input
Illustration 23: The Edit Chart Value Dialog Box, with Our Input

20.  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 24.

The Action Tab of the Edit Chart Value Dialog Box
Illustration 24: The Action Tab of the Edit Chart Value Dialog Box



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM