How to Send Cases that Belong to a Cluster into a table from DMX Query. RRS feed

  • Question

  • Hello, 

    For my project I have performed clustering using Visual studio(SSDT) and I need to extract the rows involved in each cluster. 

    I am able to select them using a DMX query similar to below: 

    SELECT *
    FROM [TM_Clustering].CASES  
    WHERE IsInNode('001')

    But I need to send them into a SQL table for further processing. 

    Can I do this? If yes then how? 

    Please guide me. 

    Thank you,

    Wednesday, July 8, 2020 12:22 PM