query XML file in a sql script

[Former Member]

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

[pfefferf]

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

[Former Member]

Hi Florian thanks a lot for your answer,

I found _SYS_REPO.ACTIVE_OBJECT, column CDATA but it's not complete, there is not all the information I need.

Do you know if there is an another way to get all the calculation view XML or information like commentary, cardianality, node'name... ?

Thanks again,

Regards

Etienne

[pfefferf]

Some additional information can be found in the BIMC_* tables in schema _SYS_BI.

[Former Member]

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

Nevertheless thank a lot you for your help