Sunday , 30 April 2017

What is the importance of SYS_BIC, SYS_REPO, SYS_BI

A schema is just like a database folder. The relavant tabels are going to group together according to the particular schema definition.

There are 3 types of schemas:

  1. User Defined Schema
  2. System Defined Schema
  3. SLT Derived Schema

User Defined Schema is created by user (DBA or System Administrator)

System Defined Schema Where all the list of tables views going to be associated.
There are 5:

  1. _SYS_BI
  2. _SYS_BIC
  3. _SYS_REPO
  4. _SYS_STATISTICS
  5. _SYS_XS-ENGINE

SLT Derived Schema: When we configure the SLT first time (by administrator) they are going to give schema name –> meaning a configure name and that configure name that is provided or configure out side the HANA in the source system or in the SLT replication server. That particular name is container of list of the tables that need to be pulled from the source system.

 

_SYS_BI: This schema stores all the metadata of created column Views.
This will hold the tables for created Variables, Time Data (Fiscal, Gregorian), Schema Mapping and Content Mapping tables.
Shortly; this schema stores all the meta data of created column views.

_SYS_BIC: Whenever we activate HANA Models, its going to be stored hear in _SYS_BIC System standard schema.
This schema will hold all the Columns Views of activated objects. When the user activates the Attribute View/Analytic, View/Calc, Priv/Procedure, the respective entry will be created under _SYS_BIC -> Column Views. When the client consumes the Views, only these column views will be exposed.
Shortly; this schema stores for all the generated run time objects. So basically when we activate the Information models/views they are created as a column views in this schema.

_SYS_REPO: Whatever the objects are there in the system is available in repository.
This schema will hold the list of Activated objects, Inactive Objects, Package details and Runtime Objects info, etc.
Shortly; this schema stores all the design time models under content.

_SYS_STATISTICS: All the system configurations and parameters.

_SYS_XS: XS stands for XML Server engine. All the 3rd party Web Services can Connect & Communicate.

 

 

Check Also

SAP HANA 403 Forbidden when accessing ALM (Application Lifecycle Management)

I am using SYSTEM login, which is no doubt the most “SAP_ALL” figures in SAP …