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
-
Economics & Finance
SAP HANA Articles
Page 53 of 58
Stop and start a tenant database in SAP HANA
A SAP HANA administrator can start tenant databases either individually, or it can also be done once by starting the whole system and same is for stopping the database.To perform this, navigate to SAP HANA Cockpit -> Open the Manage Databases app -> You have to select tenant database that you want to stop or start -> Select stop Tenant Database or start Tenant Database in the footer toolbar.The database starts stopping or starting and will be completed in few minutes.
Read MoreDifferent services to add to tenant database
Following are the main services that you may need to add to a tenant database:indexserverxsenginescriptserverdpserver
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 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 MoreMoving objects from one package to another package in SAP HANA
In SAP HANA Modeler perspective, you have an option of “Mass Copy” using which you can copy mass objects from package to other package. You have to define source and target package mapping.To add new package mapping, you can use button and select Source and Target package from drop down list. In next window, you have to select models and click on Next.
Read MoreTransporting content from one SAP HANA system to other
This can be done using Delivery unit option in SAP HANA. You can assign packages to a delivery unit using SAP HANA Studio or using Application Lifecycle Management.Then this DU can be exported and you need to specify the location- local file system, where you want to save the exported DU. This file can be imported later to add the packages to other system. In below snapshot you can see a Delivery unit is selected under Upload/Download option in HANA Application Lifecycle Management ALM. Once delivery unit is selected, use “Export to File” option to export this DU locally in ...
Read MoreUsing Switch Ownership option in SAP HANA
With use of switch ownership you can take single or multiple inactive objects from other users. Multiple Information views can be created in HANA system and all these views remains inactive until they are activated in HANA Studio. With use of Switch Ownership option, one user can take ownership of one or multiple inactive objects in HANA.You need to select inactive Information objects that you want to take from other user. From drop down list you can select source user and with use of Add button, you can add objects under selected models window.
Read MoreChanging authoring schema of catalog objects in SAP HANA
In SAP HANA Modeler perspective, you have an option of changing authoring schema of catalog objects.Select the objects for which you want to change the authoring schema from Content tab. You can use Add button to add objects Available -> SelectedFrom drop down, you need to select Authoring Schema details- Source and Target
Read MoreDefault location for installation of SAP HANA Studio
You can install SAP HANA studio on Linux platform without Root user. In Windows platform, you can perform the installation without administration rights but it will be available only to the user who has installed it.Default Location on Window Platform: C:\Program Files\sap\hdbstudioDefault installation Location under MAC OS: /Applications/sap/hdbstudio (old) or /Applications/sap/hdbstudio.app (new)Default installation Linux x86 64 bit: /usr/sap/hdbstudio
Read More