Showing posts with label bol. Show all posts
Showing posts with label bol. Show all posts

Sunday, March 11, 2012

Datamining concepts

What does cluster represent? Does anyone know any good resources for datamining

with ssas 2k5? I tried BOL but, I found out they don't seem to help that much Except to make you understand what each tab does.. any suggestions?

thanks,

Rok

Here baseline info about the Cluster Algorithm in SQL Server 2005:

(The Microsoft Clustering algorithm is a segmentation algorithm provided by Microsoft SQL Server 2005 Analysis Services (SSAS). The algorithm uses iterative techniques to group cases in a dataset into clusters that contain similar characteristics. These groupings are useful for exploring data, identifying anomalies in the data, and creating predictions.)

The first link below scroll to the end you will see all the SQL Server 2005 datamining Algorithms, the second is where you will find tutorials and the last link is the math used to create most prediction related calculations. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms175595.aspx

http://www.sqlserverdatamining.com/DMCommunity/

http://mathworld.wolfram.com/topics/ProbabilityandStatistics.html


Wednesday, March 7, 2012

Data-Driven Subscription Error

I working through the 'Creating a Data-Driven Subscription' walkthrough
supplied as part of the BOL documentation, using Report Server File
Share as the delivery method. It cannot generate the report using the
three sets of dummy user details. The resulting status is: 'Done: 3
processed of 3 total: 3 errors'. How can I resolve this error?Sounds like possibly there was an error in writing out the files to the
file share (...since 3 of 3 procesed).
Open the ReportSever_ error log (C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\LogFiles), and do a Find on 'Success:
False' to locate errors in the log, using the timestamps to narrow
down the entries you look at. Errors could include illegal file names
or permissions on file share etc.
Matt A