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 06-Feb-2018 00:36:55