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