I have succesfully created a Data Mining Model using the Association Model. I have deployed and processed it.
I need to extract all the rules that is generated by the model. I know that you normally query the model using DMX prediction queries, but in this case I need to extract the rules to a separate table for further processing.
I have tried the following approaches unsuccessfully:
1. Linked server in MSSQL Management Studio. DMX query using OpenQuery. The DMX query looks like this:
SELECT FLATTENED NODE_CAPTION, NODE_SUPPORT, NODE_PROBABILITY, MSOLAP_NODE_SCORE
WHERE NODE_TYPE = 8
On small models this method works. On larger models with many rules I receive an exception: "XML for Analysis parser: The XML for Analysis request timed out" before it was completed
This always happens after 70min. I might have missed a timeout option?
2. Using SSIS to run the same DMX query as above. The method is presented here: http://www.sqlservercentral.com/articles/MDX/64697/
This method works on small models. On larger models that did not work with method 1, it return rules. The number of rules returned is sometimes different for the same package run multiple times. For the largest models it simply returns 0 rules.
I suspect that the same XML Parser error happens under the hood of SSIS.
I'm currently stuck, and need some inp
View Complete Post