August 18, 2016 at 2:37 pm
I am experiencing trouble deploying a time series mining structure. I have a basic structure, 4 predicts, one key quarters and a attribute, essentially a code. When I deploy all the 4 predicts and key it deploys if I add the attribute, regardless of the format, continous or discrete etc it fails, it says the data type can't be coverted from varchar. Thoughts?
Querying Microsoft SQL Server 2012/2014 - Certified
August 19, 2016 at 8:38 am
I've done some additional research, according to MS websites discrete data types work with all mining structures.
https://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx?f=255&MSPPError=-2147217396
This is simply not true for 2012 BI Edition.
Ended up making the code a Key along with the date slices. Pushed everything else to predict for cross correlation for future analysis. Love the set algorithm feature that worked well. Missing values, 0 not the keys of course.
It's tough to find though, SSDT 2012/2014 (not sure which one) if you select the mining structure and select mining models you'll have to right click the model title and there you can get to the set algorithms feature.
Just thought I would share.....
Querying Microsoft SQL Server 2012/2014 - Certified
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply