I have successfully created a time series model using DMX code, but I haven't been able to export the predictions to my SQL database - the results are too large to copy/paste and I haven't been able to figure out code that will allow me to copy it directly
to my SQL database. I know you have the option to save predictions to a SQL table in Visual Studio, so I'm trying to recreate the model using the new mining structure wizard on an entirely new SSAS database in Visual Studio. When I go to deploy the structure,
it tells me that the mining structure does not exist. I'm confused because I'm trying to create the structure - of course it doesn't exist. Does anyone have any advice?
View Complete Post