Found 694 Articles for SAP HANA

Use of _SYS_REPO in SAP HANA database

John SAP
Updated on 24-Feb-2020 09:26:06

1K+ Views

In SAP HANA system _SYS_REPO user is required to create run time objects that are saved in HANA database under _SYS_BIC schema. When you activate modeling views in HANA, SYS REPO provides the read access to users on these modeling views. That is why it is required to grant _SYS_REPO with SELECT with GRANT privilege to user schemas.GRANT SELECT ON SCHEMA "SCHEMA_NAME" TO _SYS_REPO WITH GRANT OPTIONThis is required when you use objects of a table/view of a schema to build HANA Modeling Views. You need to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema.Read More

Difference between _SYS_BIC and _SYS_BI schema in SAP HANA

John SAP
Updated on 24-Feb-2020 09:29:09

2K+ Views

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

Common system schema in SAP HANA Studio under Provisioning

John SAP
Updated on 17-Jun-2020 11:15:12

118 Views

Common system schema are −_SYS_BIC_SYS_REPO_SYS_BI_SYS_XS_SYS_STATISTICS and many more

Different objects inside a package in SAP HANA

John SAP
Updated on 24-Feb-2020 09:36:24

169 Views

Following objects are available in a Package under Content tab in HANA system −Attribute ViewsAnalytic ViewsCalculation ViewsAnalytic PrivilegeStored ProceduresSub-PackagesDecision Tables

HANA Modeling objects and Content folder in SAP HANA Studio

John SAP
Updated on 24-Feb-2020 09:37:05

628 Views

In SAP HANA Studio, Content folder contains all the design time repository objects. In this folder, all objects created in HANA system are managed under packages. To create a new object, you have to first select a Package.In a package you have different HANA Modeling Views- Attribute Views, Analytic Views, Calculation Views and Analytic Privileges. Each of the object type is managed in different folder in a package.

Different database objects inside Catalog folder in SAP HANA Studio

SAP Expert
Updated on 17-Jun-2020 09:22:01

413 Views

It includes −Column ViewsEPM ModelsEMP Query SourceFunctionsIndexesProceduresSequencesSynonymsTablesTriggersViews

Database objects in SAP HANA Studio

SAP Expert
Updated on 24-Feb-2020 07:24:01

666 Views

In Catalog folder, you can see all the database objects in SAP HANA system. You can see the list of all schemas in HANA database and each schema contains different Database objects inside it. In below pic, you can see different database objects under AA_HANA11 schema object.

Checking Last successful data backup in SAP HANA

SAP Expert
Updated on 24-Feb-2020 07:25:31

1K+ Views

This can be checked in Backup configuration in HANA Studio. In Overview tab, you can see status of last successful Data Backup.

Checking currently active data backup in SAP HANA

SAP Expert
Updated on 24-Feb-2020 07:15:10

404 Views

This can be checked in Backup configuration in HANA Studio. In Overview tab, you can see status of Currently Active Data Backup.

Checking backup configuration in SAP HANA

SAP Expert
Updated on 24-Feb-2020 07:17:10

247 Views

Backup folder in SAP HANA Studio can be used to manage backup properties in HANA system. Backup properties under HANA system are specific to that system.To see the backup configuration, you have to double click on Backup folder. HANA Studio opens the backup configuration for HANA system −

Advertisements