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.

SAP Expert

Published on 23-Apr-2018 11:40:28

• Related Questions & Answers
• Difference between _SYS_BIC and _SYS_BI schema in SAP HANA
• Use of _SYS_BIC schema in SAP HANA
• Authoring schema vs Physical schema in SAP HANA
• Taking backup of schema in SAP HANA
• Using Schema mapping in SAP HANA
• Setting schema mapping in SAP HANA
• Checking list of system schema in SAP HANA
• Changing Ownership of schema in SAP HANA Database
• Checking SAP HANA Schema owner name
• Taking schema wise backup in SAP HANA
• Different schema types in SAP HANA database
• Checking schema creation in SAP HANA database
• Changing authoring schema of catalog objects in SAP HANA
• Checking list of all available schema in SAP HANA
• Checking all tables and schema in SAP HANA