What is _SYS_BIC and _SYS_REPO, and their differences?

[angel_xiao]

    What is _SYS_BIC and _SYS_REPO, and their differences? And I find it hard to understand all those schemas on SAP HANA System...

[nikhil_joy2 · Accepted solution]

Hi Angel,

Both are system users and there schemas are system schemas. Whenever we create a model and activate it, the runtime column views are created and stored under column view section of _SYS_BIC schema. Whatever we are modelling in a view cannot be accessible for front end tool like BO directly. They can access only the objects in Catalog section. So only way to get the data by front end tools is query column views in _SYS_BIC.

Whenever we create a model,_SYS_REPO user creates necessary runtime objects from them which get saved into _SYS_BIC schema. After activation _SYS_REPO gives the user read access to the activated models. This is why it is necesary to grant  _SYS_REPO with SELECT WITH GRANT previlage to the users schema.

Refer below link to see a very detailed explanation from Lars on _SYS_REPO.

http://scn.sap.com/thread/3153367

And if you are wondering why we need all these specific schemas, i think the answer would be, with the help of these system schemas, authorization and data management happen in SAP HANA.

Regards,

Nikhil Joy

[former_member744776]

SAP HANA can contain tables for different appications. Each application has its own connection to the SAP HANA database. For SAP system XYZ, the name of the primary database connection is the SAP HANA database user, SAPXYZ. For each user and for each connection there is corresponding logical section in database called schemas.

All calculation view are published in schema, SYS_BIC. This schema and all its objects belong to a standard database user, SYS_REPO.