In SAP HANA database, there are 3 types of schema −User Defined Schema: These schemas are created by database users or administrators. All the schemas under Catalog tab except from System defined and SLT derived schemas are user defined schemas.System Defined Schema: These are generated as result of using HANA related functions. These are of following types −_SYS_BI_SYS_BIC_SYS_REPO_SYS_STATISTICS_SYS_XS-ENGINESLT Derived Schema: These schema are generated as part of SLT Data replication in HANA.

Both the schema are system defined schemas. _SYS_BI schema is used to store all the metadata of created column Views.It is different from _SYS_BIC and _SYS_REPO schema and you can understand this from below −SYS_BI − This schema stores all the metadata of created column Views._SYS_BIC − Whenever you activate any HANA Modeling view, it is stored under _SYS_BIC System defined schema._SYS_REPO − Whatever the objects are there in the system is available in repository. This is used to create required run time objects.

In SAP HANA, Delivery unit is known as single unit, which can be mapped to multiple packages and can be exported as a single entity so that all the packages assigned to Delivery Unit can be treated as a single unit.Delivery units can be used to export all the packages that make a delivery unit and the relevant objects contained in it to a HANA Server or to the local Client location.The user should create Delivery Unit prior to using it. This can be done through HANA Modeler -> Delivery Unit -> Select System and Next -> Create -> Fill ... Read More

In SAP HANA system, you can see all the packages under Content tab in HANA studio. All HANA modeling objects are created inside packages. Packages can be used for migrating modeling views in HANA system.You can also create a sub-package, and different HANA modeling views- Attribute view, Analytic View and Calculation view in a package. When you expand Content tab, you can see list of all available packages. When you expand a package you can see different Attribute, analytic and calculation views in that package.You can also create Decision Table, Define Analytic Privilege and create Procedures in a Package.When you ... Read More

When you use object of a schema to build HANA modeling views then it’s necessary to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema. You need to execute the following:GRANT SELECT ON SCHEMA "" TO _SYS_REPO WITH GRANT OPTIONTo use tables from one Schema to create views we should provide access on the Schema to the default user who runs all the Views in HANA Modeling._SYS_REPO user is responsible for activating models and creating the required runtime objects from them. This is the reason you need to provide user _SYS_REPO to select objects in tables and views in ... Read More

When we create a model and activate it, the runtime column views are created and stored under column view section of _SYS_BIC schema. _SYS_BIC schema stores all the columns views of activated objects.When the user activates the Attribute View/Analytic View/Calculation View/Analytic Privilege /Procedure, the respective run-time objects are created under _SYS_BIC/ Column Views.

New tables can be created using the two methods given below −Using SQL editorUsing GUI optionThe new table can be created using SQL Create Table statement –Create column Table Test1 (    ID INTEGER,    NAME VARCHAR(10),    PRIMARY KEY (ID) );When you run this SQL query, you get a message like this:The statement 'Create column Table Test1 ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 5 ms 136 μs (server processing time: 4 ms 432 μs) - Rows Affected: 0To create a table using GUI, you need to right-click on any schema name -> New ... Read More

The following table contains generated time data in HANAM_TIME_DIMENSIONM_TIME_DIMENSION_WEEKM_TIME_DIMENSION_MONTHM_TIME_DIMENSION_YEARThese tables are represented in schema _SYS_BI

SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged in groups. Using these tiles, you can access individual applications and can also access app-specific data for immediate review.You can also perform a drill on these tiles to see the detailed information about specific applications.Following roles are required to open and access tile-based SAP HANA Cockpit − sap.hana.admin.roles:: Monitoring or sap.hana.admin.roles:: AdministratorYou can also open SAP HANA Cockpit via HANA Studio. Navigate on HANA system -> Configuration and Monitoring -> Open SAP HANA Cockpit.You can also open HANA Cockpit in an offline mode using a ... Read More

To generate time data and replicate your data, follow below steps −In the SAP HANA Studio in the Modeler perspective, on the Quick Launch tab, select the relevant SAP HANA system and choose Generate Time Data.In the field Calendar Type, select Gregorian.Enter the period for which you want to generate data. You should generate time data for all years for which data can occur in your application (Ex: 1999 to 2020).Select Granularity Day → Finish