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 May 14, 2009

Attribute Discretization: Using the "Equal Areas" Method - Page 4

By William Pearson

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

We will process the Analysis Services database within which we have been working, and then browse the Birth Date 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 asking if we would like to save changes, which appears as depicted in Illustration 10.

Click Yes to Save All Changes before Processing
Illustration 10: Click Yes to Save All Changes before Processing

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 Message Appears
Illustration 12: Process Succeeded Message 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 work.



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