Skip to Content
0

query XML file in a sql script

Jun 26, 2017 at 12:10 PM

74

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Jun 26, 2017 at 07:14 PM
1

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded
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

0

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

0
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

0