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 42 of 58
Limitations of using SAP HANA 1.0
SAP HANA 1.0 can replicate data only from few of data sources and only in few formats using Sybase Replication. You can perform batch loading using SAP Data Services and it is optimized only for Business Object 4.0 for reporting.
Read MoreDifferent Engine types in SAP HANA
In SAP HANA, following engine types are available:Join Engine: This is used for attribute viewsOLAP engine: This is used for analytic viewsCalculation Engine: This is used for calculation views
Read MoreUsing fact and dimension tables in SAP HANA Modeling
The fact table contains measure values and primary key for Dimension tables. Dim tables contain master data. Fact and dimension table are joined in HANA Modeling to achieve some business logic.Example of Measures − Number of unit sold, Total Price, Average Delay time, etc.Dimension Table contains master data and is joined with one or more fact tables to make some business logic. Dimension tables are used to create schemas with fact tables and can be normalized.Example of Dimension Table − Customer, Product, etc.Suppose a company sells products to customers. Every sale is a fact that happens within the company and ...
Read MoreGetting error while using schema in SAP HANA Modeling
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 MoreDisadvantages of using row based tables in SAP HANA
Row based tables are used when only one record has to be processed at a time. Row based table doesn’t support aggregations and fast searching.When your application needs to access a complete record or a complete row it is recommended to use row based tables.
Read MoreUsing aggregated in SAP HANA
SAP HANA is an in-memory database so all data resides in memory all the time and hence all calculations and functions can happen directly and hence materialized aggregations are not required in SAP HANA database.With the use of column store, data is available vertically and hence operations on different columns can be easily performed.
Read MoreUse of Statistics service in SAP HANA
In SAP HANA system, you use statistics serve as a key to internal monitoring infrastructure. You will be notified when a critical alert raised in your HANA environment and you can also get all the historical monitoring data for analysis.Statistical Server is responsible for collecting the data related to system resources, their allocation, and consumption of the resources and overall performance of HANA system.For more details, you can refer our SAP HANA core architecture topichttps://www.tutorialspoint.com/sap_hana/sap_hana_core_architecture.htm
Read MoreEnabling XS Engine service in SAP HANA Studio
To Configure DXC, you need to enable XS Engine (SAP HANA Extended Application Services). To enable XS Engine Change the Instance value to “1”. XS Engine Service in SAP HANA Studio is used to handle Control Flow Logic.
Read MoreChecking XS Engine service in SAP HANA system
You can try accessing XS Engine using below address in IE.http://:80 and you will get below screen to show that XS Engine is working fine.
Read MoreTable mapping while data replication from flat file in SAP HANA database
Table mapping is last step while uploading data using an Import option in HANA Studio. This shows the data that already exist in the table and also shows the information about the schema and table to which we are going to load the data.Click on Finish to load the data.
Read More