Categories report for arbitrary clustering model

Question

Hi , everybody !!!

Can I to produce a Sheet called "Categories Report" after Detect categories but for some model I am already have on SSAS server ?

Thanks

Answer 1

Getting exactly the same kind of formatted output as in Detect Categories is not possible with the current version of the add-ins.
Yet, are a few things you could do:

- use the Document Model feature of the Data Mining Client add-in (part of the Data Mining Excel ribbon)

- use the Browse Model feature of th Data Mining Client add-in (part of the Data Mining Excel ribbon). Once the cluster viewer is loaded, you could copy and paste the Cluster Profiles view which includes most of the information in the Detect Categories view (although in a less interactive format)

- manually replicate the behavior of Detect Categories. The Data Mining Client  add-in allows you to send data mining queries (DMX) to existing models. You could extract the cluster distribution information from each cluster in a single excel sheet then manually create a pivot chart similar with the on produced by Detect Categories

---

bogdan crivat [sql server data mining] / http://www.bogdancrivat.net/dm

Answer 2

Hi, Bogdan !!!

- At document model I see liklihood of mode l . How can I retrieve with DMX ?
- I want to copy Cluster Profiles automaticly since we''ll run the model each week . Therefore  am also need DMX for it . Can you  help me withthis ?
- again , I am need to know which disrtibution imformation to use and how to convert it to Pivot (like Detect Categories).

May be there is any way to allow Detect categories to accept my setting for Clusterin parameters ? It also can help

Thanks