
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 691 Articles for SAP HANA

506 Views
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

962 Views
In SAP HANA system, schema is used to group logical objects tables, Stored procedures and database views. When objects are moved from one system to other, you can consider involvement of following schema types −Authoring SchemaThis schema is used in design time views. This schema is used in creating objects in content development system. Let us say you are developing some objects in development system and schema used is Dev_schema that contains all the required tables. Dev_schema is authoring schema to create modeling views.Physical SchemaLet us say you move objects from development system to other system. In target system you ... Read More

934 Views
Schema mapping in SAP HANA is used to move objects from one system to other system i.e. from Development system to Test or Test system to production system.Let us say you are moving objects from Dev system to production system and tables in dev system are available in Dev_SCH and same set of tables are also available in production system in Prod_SCH. Now when you move a HANA Information view from Development to production, it will not work as dev_SCH is referenced in Information view definition so in this scenario, you need to perform schema mapping in target system. Read More

2K+ Views
I don’t think you can change ownership of schema in database. Easiest way to change ownership of schema is by exporting a schema, drop it from the database and then recreate the schema owned by the target user and import the objects back into the database.In recent version, you can create schema and set other users as an owner of the schema however you can’t change it later −Create SCHEMA TEST123 owned by Demo;In same way, you can collect the script for "Create procedure" from database and drop the procedures in the earlier user schema and then these can be ... Read More

515 Views
Below is the difference between take over and switch ownership.Take Over: This option is used to take single inactive object from another workspace.Switch Ownership: This option is used to take single or multiple inactive objects from other users.When you expand Switch ownership option in HANA Modeler, you can see description of this option-

1K+ Views
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.