Where do the comments (in hana views) are stored ?

[amauryvanespen]

Good morning,

I'm looking for the table in which the comments on objects are stored

(related to this topic : https://help.sap.com/viewer/e8e6c8142e60469bb401de5fdb6f7c00/1.0.12/en-US/96e32792ae784fd28f9bbb1619...

Would you be kind to let me know where to find the content of these comment are stored for my custom calculation views ?

Thank you

[lbreddemann · Accepted solution]

As far as I can see these comments are not officially available by anything else then the calculation view editors.

Looking into where the old repository (up to and including HANA 1 SP12) stored the repository model one finds the tables _SYS_REPO.ACTIVE_OBJECTS and _SYS_REPO.INACTIVE_REPO.

For each repository object there exists at least one record in either of these tables. The actual modelling information is stored as an XML file in the column CDATA.

For a calculation view - at least on my test system - I can find the comments entered in the modeler UI in tags like

...
<descriptions defaultDescription="ST_DTTEST">
    <comment text="Here's the final data coming
"/>
</descriptions>
...

[amauryvanespen · Accepted solution]

Great !

Thank you lars.breddemann

I'm going to dig a bit more the question, but this is already a nice answer.

[amauryvanespen · Accepted solution]

Good morning lars.breddemann

Two more question about the same subject.

Firstly, in what kind of data type can i cast the NCLOB Data Type to get the whole content ?

Secondly, related to those posts :

- extended Where-used search

- Template for Auto Documentation in Eclipse

I would like to know which package in HANA Tools is involved and how could I suggest to implement an add-in to the Auto Documentation with the comments. (who is the right people @SAP or which Influence Area should I contact)

Thank you

[lbreddemann · Accepted solution]

Ok, so for the data type question, it really is only NCLOB (and of course a corresponding BLOB) that could capture the whole content in a guaranteed fashion. As soon as you cast it to a character data type, say NVARCHAR, you loose data that is "behind" the length limitation of the target data type. With NVARCHAR that'll be 5000 characters.

If you look around a bit, you'll find that the SQL/SQLScript options to deal with LOBs are rather basic. That means, for most meaningful work with these data types, you'll need a client application that can deal with that data.

Concerning your ideas for improvements, the SAP HANA Platform session is the right one here.
As already explained in a different thread, SAP HANA Studio is marked as deprecated, which means that it will eventually "go away". Therefore, I suggest to get familiar with the new development and modelling tools (WEB IDE).

[amauryvanespen · Accepted solution]

Thank you lars.breddemann

I've tried some script to catch the content with string function, currently, without success

main objective is to get the value of text attribute for a related element, here "CDATA" (by the way, getting the related value of parent element name attribute, here "XML") for each child node pattern

<endUserTexts label="*">
 <comment text="*"/>
</endUserTexts>

in

<element name="XML" aggregationBehavior="NONE" drillDownEnablement="DRILL_DOWN">
      <endUserTexts label="XML">
        <comment text="CDATA"/>
      </endUserTexts>
      <inlineType name="NVARCHAR" primitiveType="NVARCHAR" length="50" precision="0" scale="0"/>
    </element>

I understood that I can get the length of le LOBs and use it to get an export through SQL

Any suggestion on how-to perform this properly ?

[amauryvanespen · Accepted solution]

Good morning lars.breddemann ,

The campaign doesn't exist or I'm not allowed to be involved :

Object does not exist or access is denied

Thank you

Amaury

[lbreddemann · Accepted solution]

The link works for me, so maybe you need to register before accessing it.

I'm not too much involved with that, so all I can do is point you to the main page https://www.sap.com/about/customer-involvement/influence-adopt.product-category.html#overview

[amauryvanespen · Accepted solution]

OK, thank you lars.breddemann the Campaign 902 is probably finished due to development discontinuation of product.