SQL Server Developer Center > SQL Server Forums > Data Mining > Drillthrough for PredictHistogram column results.
Ask a questionAsk a question
 

QuestionDrillthrough for PredictHistogram column results.

  • Monday, October 26, 2009 5:39 AMKatie Malecka Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I was hoping I wouldn't run into any more problems, but keep failing on the one last thing I want to do in my project. I am getting 50 user id's from the  query rok1 has kindly helped me out with:

    SELECT FLATTENED
      TopCount(PredictHistogram([model].[CustomerId]),$adjustedprobability,50) AS Predicted
    FROM
      [model]
    NATURAL PREDICTION JOIN
    (SELECT (SELECT 'Whiskas' AS [Product] UNION SELECT 'Chappie' AS [Product]) AS [Itemid View]) AS t

    I would like to use Predicted.CustomerID from the query above as an input to a DMX query to drill through to the data in the mining structure, where a mail address is stored for each of the CustomerIDs. Is it even remotely possible? Given the nature and the scope of the analysis, I cannot do it manually for each of the CustomerIDs, I need to use the column from the aforementioned query as the input.

    Thanks in advance,
    Katie