I am trying to run the DMX query
from [TK448 Ch 009 Prediction]
natural prediction join
(select 'm' as [gender],
0 as [number of cars owned]) as t
for my [TK448 Ch 009 Prediction] model but it's throwing me the error "'xxxxx\Administrator'user does not have permission to access the 'Local' object, or the object does not exist" though it has the Admin permission.
The full query what I am trying to achieve is.
--select * from [predictioncluster].cases
select top 1000
predictprobability([bike buyer],1) as dtpredictprobability,
t.numbercarsowned from [predictioncluster]
from [dbo].[prospectivebuyer]') as t
on[gender] = t.[gender] and [number cars owned]
where [bike buyer] = 1
order by predictprobability([bike buyer],1)desc
but the same error. Also I am getting the error "The end of the input was reached". If any one could help me out with this issue.
View Complete Post