- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
- >ABAP Constants & Literals
- >ABAP Constants & Literals
- >Types of Tables in SAP
- >Sap Data Object
- >Internal Tables and Work areas
- >Internal Table Operations in SAP ABAP
- >ABAP Report uses Internal tables and Work Areas
- >Select single and Select up to 1 rows
- >Modularization Techniques
- >Techniques of debugging
- >Types Subroutines
- >Reports of Sap Abap
- >Using At Selection Screen Output
- >Select Statements
- >Function Modules
- >Modularization Techniques 2/
- >Subroutines In Sap Abap/
- >Report Of Sap Abap 2
- >Using At Selection Screen Output 2
- >Interactive Reports
- >Interactive Reports Development
- >Interactive Report Using Hide Technique
- >Interactive Report Using Get Cursor Technique
- >Tree List Report
- >Abap Alv Reports/
- >Sap scripts/
- >Purchase Order SAP Script/
- >SAP Smartforms/
- >What is BDC in SAP ? Types of BDC ?/
- >BDC Call transaction for Material Master MM01/
- >SD flow with T-Codes and tables/
- >Introduction to module pool programming in SAP/
- >Functional Specification/
- >ASAP methodology SAP
- >ABAP Development end to end process in Companies
- >SAP SD Sales and Distribution
- Accounting Entries in SAP FICO
- Define Company in SAP
- Creating new companies
- Assign Company Code
- Business Area
- Functional Area
- Credit Control Area in SAP
- Financial Management in SAP
- Segments in SAP
- SAP Enterprise Structure
- General Ledger Accounting
- Fiscal Year Variant in sap
- Posting Period Variants in SAP
- Posting Period Variant to Company Code
- How to Assign company code to field status variants in SAP
- Posting Keys in SAP
- Tolerance Group for Employees in SAP
- Tolerance Groups For G/L Accounts
- Assign Users to Tolerance Groups in SAP
- Enter Global Parameters for Company Code OBY6
- Define Additional Local Currencies for Company code in SAP System
- Chart of Accounts in FICO
- Assign Company Code to Chart of Accounts in SAP
- How to Create G/L Account Group in SAP
- Define Sample Account Rule Types in SAP
- Data Transfer Rules
- Convolutional and recurrent neural network
- Assign company code to rule type in sap
- Create sample account in sap
- Accounting entries in sap fico sap accounting postings
- Financial statement versions in sap
- TAX Check Calculation Procedure in SAP
- Define New Condition types for Taxes
- How to Assign Country to Calculation Procedure
- Specify Structure for Tax jurisdiction code
- How to Create tax codes in SAP – FTXP "FI"
- Assign Tax Codes for Non-Taxable Transactions in SAP FI
- Define Tax Calculation Procedure for GST in SAP"FI"
- Assign Tax Calculation Procedure to Country in SAP for GST"FI"
- Define Access Sequence in SAP for GST"FI"
- Define Condition Types in SAP for GST"FI"
- How to create customer account groups in sap
- How to create number ranges for customer accounts
- Assign number ranges to customer account groups
- How to Assign Number Ranges to Vendor Account Groups in SAP F1
- How to Create Sundry Creditors GL Account in SAP FI
- How to Define Tolerance group for vendors /Customers
- How to Create Vendor Master Data
- Automatic Payment Program Configuration Steps SAP FI
- Create Vendor Account Groups in SAP
- How to Create Number Ranges for Vendor Accounts in SAP
- Maintain terms of payment SAP
- How to Create Customer master data by XD01
- How to Define Dunning Procedures in SAP
- Copy Reference Chart of Depreciation in SAP
- Assign Chart of Depreciation to Company code in SAP
- Specify account determination asset accountng
- How to create screen layout rules asset accounting
- SAP FI: Create Screen Layout Rules
- SAP FI: Maintain Asset Number Ranges – AS08
- Create Investment Program Types in SAP
- Investment profiles
- How to Investment Program Types to Operative objects in SAP
SAP HANA Studio Administration Console – Add Schema, Table, User
SAP HANA Studio Administration Console/ View
Administration Console view is one of the many perspectives offered to work in the SAP HANA Studio. SAP HANA Studio is an Eclipse-based tool which serves as both the central application development environment as well as the core administration and monitoring platform for the HANA system.
You can select the Administration Console from the first window that appears upon opening the SAP HANA Studio.
The SAP HANA Studio Administration Console opens. However, in some cases, it opens directly if it is set as the default browser.
A lot of administrative tasks can be performed in the SAP HANA Studio such as regulating (start/stop) services, monitoring the system, user management and authorization, backup and recovery, audit policy and security configuration, license management, alerts and messages, memory management etc. All of the mentioned activities can be achieved from different tabs present in the administration console such as,
- Overview (general management and monitoring).
- Landscape (checks if all the services are running).
- Alerts (set and view the details of the alerts).
- Performance (checks the performance of the system for the activities taking place on the database).
- Volumes (details of the data volumes and logs.
- Configuration (contains the details of system configuration files).
- System Information (to access system information files and queries).
- Diagnosis Files (contains the system log files).
- Trace Configuration (contains the traces set up information).
How to add a system in SAP HANA Studio Administration Console?
In order to work on the administration console, we have to load database systems into the Studio. This connects the client (user) to the SAP HANA database. Let us learn how to add data systems in the administration console.
On the Administration Console view, right-click on the left panel and a drop-down menu appears. Select Add System..from the menu.
Enter the database specific credentials like Hostname, Instance number, description of the database etc. Click on Next to continue.
To add the system and access the database in SAP HANA Studio, you need to be an authenticated user with authorized username/ID and password. Then click on Finish.
The system gets loaded and you can see the hierarchical view of all the components and categories of the system on the panel. For each system, there are four folders, Catalog, Content, Provisioning, Security plus a Backup folder which are dedicated to providing specific services.
You can find data tables by drilling down in the hierarchical system folders.
Also, you can perform several operations on the table as shown in the menu in the screenshot below. You can view a table’s content etc. from this menu.
How to add a schema?
In the Catalog folder, you can find schemas of all the loaded databases in the system. The schema contains folders which organize a database properly. The folders are Column view, Functions, Indexes, Procedures, Sequences, Tables etc. Let us learn how to add a new database schema.
Open the SQL Console from the icons given at the top after clicking on the database system’s name in which you wish to add a schema.
Enter the statement in the SQL Console to create the new schema. Name the schema as you like. Click on the green Execute button.
A new schema with the name Live2 is added in the system.
You can add a new table as well by right-clicking on the tables folder.
How to add tables in a schema?
You can add new tables within a schema through the SQL Console. Enter the code which is a statement specifying all the table details. Click on the green execute button and the table will be added.
Refresh the Tables folder in the schema and the newly created table “Member” will appear in the list. You can add more tables like this.
How to add a user in a schema?
You can add a new user and give it access to the system by going to the Security folder. Right-click on the Users option and select New User.
Enter the username and password for the new user.
We can add a new user to the user’s list.
Also, you can grant specific privileges to the new user i.e. they are only allowed to perform certain actions in the system and manipulate data.
Hence, a new user with the name LIVE2USER is created having access to limited tables and is granted distinct privileges.
Now, for instance, if we try to delete a table, we will get an error message for restricted user privilege as the user is only allowed to read the table contents and not delete them.
Log Off/Login in SAP HANA Studio
You can log in and off a SAP HANA System by right-clicking on the system’s name and selecting Log Off from the drop-down menu. This will end all the existing connections from that system.
You can also log in to the system by doing the same and selecting Log In from the drop-down menu.