Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In SAP HANA, packages are used to store design time repository objects under the Content folder in HANA Studio. You have two types of the package in HANA system:Structural This package only contains sub-packages and doesn’t store repository objects.Non-Structural This package stores both repository objects and sub-packages.
XS is a Web server responds to provide a development platform and provides end to end support for web-based applications.XS engine helps external Java and HTML based applications to access HANA system with help of XS client. As SAP HANA system contains a web server which can be used to host small JAVA/HTML based applications.
_SYS_STATISTICS- This schema stores all system configuration and parameter details of HANA system.You can find this under Catalog folder in HANA Studio once you select relevant HANA system in System pane.
This can be checked under Configuration tab in HANA Administration. You need to scroll down and there you can check details under xsengine.ini
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.
With the use of SAP HANA Live Browser, you can easily browse and tag SAP HANA content views and they can be easily consumed SAP Lumira or SAP BusinessObjects (BOBJ) Analysis to analyze the data. This is based on SAP UI5 Web-based application.
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.
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.
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
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