Get Dicision Tree Attribute Name Using VB.net

Hello All,



I am going through the Data Mining Web Control sample and have that working beautifully. I now want to add in some more functionality by allowing the end user to select the: database, model and tree to view in the web viewer (similar to the parameters in SSRS). I am trying to figure out a way to get all this data programatically. So far this is what I have:




Code Snippet

For Each newDB As Microsoft.AnalysisServices.Database In myserver.Databases

dbName = newDB.Name.ToString

myLog.AppendText("DATABASE NAME - " + dbName + vbCrLf)

For Each newStructure As Microsoft.AnalysisServices.MiningStructure In newDB.MiningStructures

structureName = newStructure.Name.ToString

myLog.AppendText(" STRUCTURE NAME [ " + structureName + " ]" + vbCrLf)

For Each newModel As Microsoft.AnalysisServices.MiningModel In newStructure.MiningModels

modelName = newModel.ToString

modelAlgorithm = newModel.Algorithm.ToString

myLog.AppendText(" MODEL NAME -" + modelName + " " + modelAlgorithm + vbCrLf)



This works beautifully but I am having a problem getting the tree name which i believe its called the "attribute_name".



I can run the following SQL against Analysis Services and get the attribute name but I would like to get all this programatically and insert into a table.




Code Snippet

SELECT attribute_name

FROM [model].content

WHERE node_type=2



I plan to run this daily and update a table. This will ultimately let me pull the structure into my data mining viewer page. This way, I will only have to have one viewer page for all models, instead of a new page for each.



Thanks,

Cam