A database schema enables you to logically group together objects such as tables, views, and stored procedures. Without a defined schema, you cannot write to the catalog. SAP HANA Extended Application Services (SAP HANA XS) enables you to create a database schema as a transportable design-time file in the repository.
When you add a HANA system in HANA Studio, you can see different tabs under system pane. Each pane has different object types of HANA system. To see the list of all schema and tables, you need to navigate to Catalog tab.
Procedure
- Start the SAP HANA studio.
- Open the SAP HANA Development perspective.
- Open the Project Explorer view.
- Create the schema definition file.
- Define the schema name.
- Save the schema file.
- Activate the schema.
- Grant SELECT privileges to the owner of the new schema.
Procedure
- Log on to the SAP HANA database of your system within SAP HANA Studio.
- In the security folder, open the _SYS_REPO user.
- Go to the Object privileges tab.
- Choose Add.
- Enter the default SAP system schema.
- Select at least the “SELECT” and “EXECUTE” checkboxes in the Privileges box.
- Deploy (F8).
Definition. The payroll schema contains calculation rules to be used by the payroll driver during payroll. SAP has developed country-specific schemas which are based on schema X000. With country-specific reports, the first character in the name refers to the country indicator (for example, D for Germany, F for France).
Calculation Views are used to consume Analytic, Attribute and other Calculation Views. They are used to perform complex calculations, which are not possible with other Views. There are two ways to create Calculation Views- SQL Editor or Graphical Editor. Built-in Union, Join, Projection & Aggregation nodes.
In Classic star schema, dimension and master data table are same. But in Extend star schema, dimension and master data table are different. In Classic star schema we can analyze only 16 angles (perspectives) whereas in extended star schema we can analyze in 16*248 angles. Plus the performance is faster to that extent.
Schema groups are then assigned to purchase organizations in customizing and to vendors in vendor master record. They are used to map the pricing determination process based on the vendor or purchase organization. Step 1) Choose Define Schema Group from SPRO IMG path like in the previous topics.
SAP HANA Packages are shown under Content tab in HANA studio. When we right click on the Package we get 7 Options: We can create HANA Views Attribute Views, Analytical Views, and Calculation Views under a Package. You can also create Decision Table, Define Analytic Privilege and create Procedures in a Package.
An SAP HANA database consists of multiple servers, for example, name server, index server, preprocessor server, and so on. The name server contains landscape information about the system as a whole, including which tenant databases exist. It also provides indexserver functionality for the system database.
SAP HANA Platform Software Components
- SAP HANA Database.
- SAP HANA Client.
- SAP HANA Studio.
- SAP HANA XS advanced runtime.
- SAP HANA XS Engine.
- SAP HANA Advanced Data Processing.
- SAP HANA Spatial.
Procedure
- Open SAP HANA studio.
- In the SAP HANA Development perspective, open the Repositories view.
- In the Repositories view, choose File New Repository Workspace .
- You must provide the following information: SAP HANA system.
- Click Finish.
- Remove a repository workspace.
It provides a setting for Administration, Data Provisioning and Modeling. The several predefined User Interface plans that addresses several applications forms are the perspectives of SAP HANA Studio. There are 2 main sub-nodes of every HANA system in HANA studio.
The backup catalog stores information about the data and log backups that were executed for a database. This includes backups that were scheduled using the DBA Planning Calendar as well as using other tools such as SAP HANA studio. The log backups are not displayed in blocks as there is only one log backup.
How to Create / Delete HANA Database Schema
- Step 1: Login to your HANA Studio and launch the SQL query page. Hit below command.
- Step 1: Right click on the schema and select Delete.
- Step 2: Select Cascade and this will delete all the objects and its dependent.
