Use of _SYS_BI schema in SAP HANA

Both the schema are system defined schemas. _SYS_BI schema is used to store all the metadata of created column Views.

It is different from _SYS_BIC and _SYS_REPO schema and you can understand this from below −

SYS_BI − This schema stores all the metadata of created column Views.
_SYS_BIC − Whenever you activate any HANA Modeling view, it is stored under _SYS_BIC System defined schema.
_SYS_REPO − Whatever the objects are there in the system is available in repository. This is used to create required run time objects.

Published on 23-Apr-2018 15:10:28