DMX Content Query

From: "Erhan Erisken" <eerisken@xxxxxxxxxx>
Date: Mon, 11 Dec 2006 09:30:24 +0200

hi all,

I want to write a content query against my Clutsering model...
I have figured out smt like this:
SELECT FLATTENED
(SELECT ATTRIBUTE_NAME, ATTRIBUTE_VALUE, [SUPPORT], [PROBABILITY]
FROM NODE_DISTRIBUTION ) AS d
FROM PersonelCluster1MM.CONTENT
WHERE Node_Type = 5 AND NODE_CAPTION = 'Cluster 1'

But, what I really want to do is to get a list of clusters together with the
most important attributes contributing to that cluster.
I tried to use 'top 10' and 'order by Probability', but it gives errors,
either says options are not allowed in sub-select, or smt like that...

Is there any idea or any resource explaining how to make content querires in
depth...
Thanks...

.

Follow-Ups:
- RE: DMX Content Query
  - From: Bogdan Crivat

Prev by Date: Re: Forecasting Model Viewer - Help
Next by Date: Report Server and Data Mining Connection error
Previous by thread: Re: Forecasting Model Viewer - Help
Next by thread: RE: DMX Content Query
Index(es):
- Date
- Thread

Relevant Pages

Re: Refining query
... "SMT" wrote: ... Jerry Whittle, Microsoft Access MVP ... I have a query which selects the most recent record that works great ... FROM project_manager AS PM INNER JOIN (enterprise_executive AS E INNER ...
(microsoft.public.access.queries)
Re: Refining query
... "SMT" wrote: ... The user choses reporting date from Forms!frmRptQuery!Combo0. ... The query shows the latest data for projects on or before the date chosen ... a new Excel "table" ...
(microsoft.public.access.queries)
Re: Results on Combo Box selection or last update
... SMT wrote: ... want to see all 7 records but when I run the query for 9/28/2007 I should see ... I'm not sure if the DateID field is ... MVP ...
(microsoft.public.access.queries)