What is the importance of SYS_BIC, SYS_REPO, SYS_BI

[Former Member]

What is the importance of SYS_BIC, SYS_REPO, SYS_BI?

Thank you very much for the helpful info.

[hai_murali_here · Accepted solution]

Hi,

All these are system related Schemas which gets created automatically.

Please find the importance of each

_SYS_BIC : This schema will hold all the Columns Views of activated objects.When the user activates the Attribute View/Analytic VIew/Calc View/Analytic 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.

_SYS_REPO : This schema will hold the list of Activated objects,Inactive Objects,Package details and Runtime Objects info,etc

_SYS_BI : This will hold the tables for created Variables,Time Data(Fiscal,Gregorian),Schema Mapping and Content Mapping tables

Rgds,

Murali

[former_member1334]

Hi,

_SYS_BI : This schema stores all the meta data of created column views.It contains tables for created variables,Time Data(FISCAL,Gregorian),schema mapping and content mapping tables.

_SYS_REPO : This schema stores all the design time models under content.

_SYS_BIC : This schema stores for all the generated run time objects.so bascially when we activate the Information models/views they are created as a column views in this schema.

Regards,

Charles

[bhargav_bhatt]

Hi,

SYS_BI:  This schema stores all the metadata of created column Views.

_SYS_BIC: Whenever we activate HANA Models, its going to be stored hear in _SYS_BIC System standard schema

_SYS_REPO: Whatever the objects are there in the system is available in repository

_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.

please refer

Regards

Bhargav Bhatt