Hello,
How do I get n and only items predicted by a specific item(s) either directly or indirectly as shown in the dependency network diagram?
For instance, the predict function won’t work for me - because running this query on AdvantureWorks:
SELECT PREDICT([Association].[Products], 5)
From [Association]
NATURAL PREDICTION JOIN
(SELECT (SELECT 'Touring Tire Tube' AS [Model]) AS [Products]) AS t
Returns Sport-100 as a second result, although it is not predicted by any mean by Touring Tire Tube as shown in the dependency network diagram.
My query should have returned just one row - Touring Tire.
See this tip and trick
Returning Associative Predictions Based Solely on Rules
Note that the Dep Net only shows pairwise rules so this technique may still return more results if there are rules that don't show in the Dep Net. You can avoid this by setting the maximum itemset length to 2.
sql
No comments:
Post a Comment