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 Jun 23, 2009

Attribute Discretization: Using the "Clusters" Method - Page 4

By William Pearson

Process the Analysis Services Database to Update Structure for Our Discretization Settings

We will process the Analysis Services database within which we have been working, and then browse the Sick Leave Hours attribute members to confirm that we have provided preliminary answers to the client’s stated requirements.

1.  Right-click the Analysis Services project atop the tree in the Solution Explorer.

2.  Select Process ... from the context menu that appears, as shown in Illustration 9.

Select Process ... to Process the Analysis Services Project
Illustration 9: Select Process ... to Process the Analysis Services Project

3.  Click Yes on the dialog telling us that the server content appears out of date, and asking if we would like to build and deploy the project first, which appears as depicted in Illustration 10.

Click Yes to Build and Deploy the Project First ...
Illustration 10: Click Yes to Build and Deploy the Project First ...

Information updates on the server, and then the Process Database dialog appears, as shown in Illustration 11.

The Process Database Dialog Appears ...
Illustration 11: The Process Database Dialog Appears ...

4.  Click the Run button on the dialog.

The Process Progress viewer appears, and generates periodic status updates for various processing events. When processing is complete, we see a Process succeeded message appear in the Status bar in the lower part of the viewer, as depicted in Illustration 12.

Process Succeeded Massage Appears ...
Illustration 12: Process Succeeded Massage Appears ...

5.  Click the Close button on the Process Progress viewer to dismiss the viewer.

6.  Click the Close button on the Process Database dialog to dismiss the dialog.

We are now ready to return to the Dimension Designer browser to examine the results of our handiwork.

Browse the Newly Discretized Attribute with the Dimension Browser

1.  Click the Browser tab in the Dimension Designer.

2.  Ensure that Sick Leave Hours remains selected in the Hierarchy selector atop the Browser tab.

3.  Click the Reconnect button atop the tab, as shown in Illustration 13.

Partial Browser View - before Reconnecting
Illustration 13: Partial Browser View - before Reconnecting

The browser details update, and (assuming the All Employees level remains expanded in the browser), we see ten groups appear, as depicted in Illustration 14.

The Discretized Attribute Member’s Groups
Illustration 14: The Discretized Attribute Member’s Groups

We see the groups appear, as expected. Ten groups have been created, based upon the algorithm selected by the Clusters discretization method.



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


















Thanks for your registration, follow us on our social networks to keep up-to-date