Post reply

Reading XML data in MDX ?

  • September 19, 2014 at 4:03 am

    #150778

    Hi All,

    I am trying to read XML data from an XML datatype columnin MDX

    The query i am using is

    SELECT lock_object_id ,lock_type

    FROM $System.DISCOVER_LOCKS

    I want to read the data from lock_object_id separately so as to apply the condition on it.

    Could someone help.

    Thanks.

  • September 19, 2014 at 7:17 am

    #1746709

    I don't know if there's a way to parse xml column in SSAS directly, but you could create a linked server to your AS instance on a SQL instance and use OpenQuery. Then you could use the xml capabilities of SQL.

    http://support.microsoft.com/kb/218592

    I'm on LinkedIn

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply