Re: Data Mining Breaking Changes?

Thank you again, this makes much sense for me now!

Dejan Sarka

"Bogdan Crivat [MSFT]" <bogdanc@xxxxxxxxxxxxxxxxxxxx> wrote in message news:OT0icoNHJHA.4060@xxxxxxxxxxxxxxxxxxxxxxx
This is a bit more complex. SQL 2000 used MINIMUM_LEAF_CASES (for DT) and MINIMUM_CLUSTER_CASES (for Clustering)

SQL 2005 exposes MINIMUM_SUPPORT instead of the above parameters in both cases. The old parameter names are not exposed. However, they are still supported for backward compatibility. SO the BOL reference to 2005 is not a typo.

SQL 2008 does not change this behavior: the parameters are not exposed (it is the MINIMUM_SUPPORT that is exposed), but they are still handled for backward compatibility in DMX.


The intention is to fully deprecate the old parameter names (..LEAF_CASES and ...CLUSTER_CASES) and BOL is trying to push users into the new direction. Consequently, the old names are no longer officially supported, all new DMX scripts should use the new syntax.

To conclude: it is not a bug, it is an undocumented backward compatibility feature. BOL is trying to teach the users the "right" direction (which is supported).


--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@xxxxxxxxxx> wrote in message news:O2CKyj8FJHA.2112@xxxxxxxxxxxxxxxxxxxxxxx
BOL 2008, Breaking Changes to Analysis Services Features in SQL Server 2008
(http://msdn.microsoft.com/en-us/library/ms143742.aspx) page says:

Previous versions of Analysis Services support using the MINIMUM_LEAF_CASES
parameter with the Microsoft Decision Trees algorithm, and the
MINIMUM_CLUSTER_CASES parameter with the Microsoft Clustering algorithm.
Since SQL Server 2005 Analysis Services, both of these parameters have been
renamed to MINIMUM_SUPPORT. If these parameters were used in mining models
created using the previous version of Analysis Services , the parameters are
not migrated.

From my tests, in SSAS 2008, they are migrated and even used in processing
the model. BTW, there is definitely a typo in BOL, as you can see from the
copied from BOL referring to SSAS 2005 and not 2008. Nevertheless,
forgetting about the typo, I am interested whether this behavior in SSAS
2008 is intended, is it a bug, undocumented feature, or simply an error in
BOL.

--
Dejan Sarka




.

Relevant Pages

  • Re: Data Mining Breaking Changes?
    ... SQL 2005 exposes MINIMUM_SUPPORT instead of the above parameters in both ... and ...CLUSTER_CASES) and BOL is trying to push users into the new ... Previous versions of Analysis Services support using the ...
    (microsoft.public.sqlserver.datamining)
  • Re: Log-off detection by service
    ... exposes some user/session specific events which can detect the change on ... logon sessions on the machine. ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.general)
  • Re: Accessing webservices from VC++
    ... WS support is now default available. ... choice which exposes the WS functionality through a COM interface. ... >web service. ... >patient to their database) as well as request data from the service (an ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Satan -- Your Mailbox is Full
    ... The Constitution of the United States of America exposes you. ... officers who spread your lies and disinformation about Lyme disease. ... Support Alex Jones.!!! ...
    (sci.med.diseases.lyme)
  • Satan -- Your Mailbox is Full
    ... The Constitution of the United States of America exposes you. ... officers who spread your lies and disinformation about Lyme disease. ... Support Alex Jones.!!! ...
    (sci.med.diseases.lyme)
Loading