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.

Updated on: 24-Feb-2020

2K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements