Difference between _SYS_BIC and _SYS_BI schema in SAP HANA

_SYS_BIC schema in SAP HANA database is used to store column views of all the activated objects in HANA repository.  When an object is created and activated (HANA Modeling views, Stored Procedures), run time objects are saved under _SYS_BIC/Column views in database.

These column views are used by front-end tools like BusinessObjects to get the data in a query.

_SYS_BI:

This schema in HANA system stores table created for variables, time dimension- Gregorian, Fiscal and schema and content mapping tables.

John SAP

Published on 05-Feb-2018 20:06:55

• Related Questions & Answers
• Use of _SYS_BIC schema in SAP HANA
• Use of _SYS_BI schema in SAP HANA
• Authoring schema vs Physical schema in SAP HANA
• Checking all tables and schema in SAP HANA
• Difference Between Schema and Instance
• Difference between SAP ERP and SAP S/4 HANA
• Using Schema mapping in SAP HANA
• Setting schema mapping in SAP HANA
• Checking SAP HANA Schema owner name
• Difference Between Star and Snowflake Schema
• Difference between Star schema and Snowflake schema in SQL Server
• Taking schema wise backup in SAP HANA
• Taking backup of schema in SAP HANA
• Different schema types in SAP HANA database
• Checking schema creation in SAP HANA database