Skip to Content

Meta data storage location of modelling views

Nov 10, 2016 at 12:51 PM


avatar image

Where is the meta-data storage location of modelling view?

Namely I am looking for:

  • View is a graphical calculation view
  • View-properties:
    • Default Client: Cross Client
    • Execute in SQL Engine
  • Filter on columns (show if some column names appear)
  • Read commends (we have a rule which states that each calculation view must have a commend in the semantics, which explains the purpose of the view)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Nov 13, 2016 at 12:06 AM

Ok, this is the second time I'm submitting my answer to this question now... #justanotherbug of the new Q&A platform?

Anyhow, here we go:

The model definitions are stored in string format (XML or JSON) and can be accessed via views like _SYS_REPO.ACTIVE_OBJECT.

You can check the string for certain settings, e.g. like this:

SELECT package_id, object_name, object_suffix, cdata,
           when locate (cdata, 'enforceSqlExecution="true"') > 0 then
        else 'FALSE'
        end as IS_SQLENGINE_FORCED
FROM _sys_repo.active_object
where object_suffix='calculationview'
and lower(object_name)='test';

As the string format is not officially/externally documented, you want to be careful with your script results after a SAP HANA upgrade. SAP HANA development can (and probably will) change the definition and meaning of the tags inside the model string without any external documentation on that.

10 |10000 characters needed characters left characters exceeded