Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 17 of 58
Getting statistics details of SAP HANA system
_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.
Read MoreChecking configuration of XS service in SAP HANA
This can be checked under Configuration tab in HANA Administration. You need to scroll down and there you can check details under xsengine.ini
Read MoreUse of _SYS_BI schema in SAP 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.
Read MoreUse of SAP HANA Live browser
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.
Read MoreDifferent schema types in SAP HANA database
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.
Read MoreUse of _SYS_BIC schema in SAP 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.
Read MoreTables for generated Time data in SAP HANA
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
Read MoreGenerating time data in SAP HANA
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
Read MoreDetails available under M_BLOCKED_TRANSACTIONS System View in SAP HANA
The following information is available under SAP HANA M_BLOCKED_TRANSACTIONS System View
Read More