Skip to Content
avatar image
Former Member

query XML file in a sql script

Hello,

I'm working on SAP HANA .

I need information on calculation view like cross client or not, commentary on node, cardinality...

Those information are in XML file off the calculation view. It's is possible to extract it with a procedure ?

During my research i found this : https://archive.sap.com/discussions/thread/3600091

I hoped that now it would be possible.

If you have any idea, please share with me,

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 26, 2017 at 07:14 PM

    There is no out of the box procedure to my knowledge.

    For XS classic you can find the calculation view XML in table _SYS_REPO.ACTIVE_OBJECT, column CDATA, from which you can extract the data using HANA SQL string functions (like e.g. LOCATE).

    Since HANA 2.0 SPS00 functions like XMLEXTRACT and XMLEXTRACTVALUE are available to extract tags/values from an XML document using XPATH query.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Florian Pfeffer

      I had already noticed these tables. However they do not contain the information that I seek.

      Nevertheless thank a lot you for your help