This query gives the observations of a node when you specify a node ID:
SELECT * FROM OPENQUERY(AnalysisServer, 'SELECT * FROM [MyDataMiningModel].Cases Where IsInNode('NodeID')') As DMX
Is there a way to get the observations along with their Node ID for the entire tree?
Meaning, getting a table that contains all the tree information, which looks like that:
[Header1], [Header2], [Header3], [NodeID]
View Complete Post