Skip to Content

Meta data storage location of modelling views

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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,
            case
               when locate (cdata, 'enforceSqlExecution="true"') > 0 then
                'TRUE'
            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.

    Add comment
    10|10000 characters needed characters exceeded