SAP HANA Articles - Page 3 of 58

When you have to export a HANA Model, right click on Semantic layer -> Export Diagram..It will give you an option to export it as an image. Click Ok and browse the location to save the file locally.

In SAP HANA, you can delete all inactive objects in workspace. In HANA Modeler Perspective → Delete Inactive Objects..You can also revert to last active version if exists.

Navigate to SAP HANA Modeler Perspective -> Repair Dependencies. You need to select a repair type and folder to save repair job log -> Next

In SAP HANA Modeler perspective, you have Repair Dependencies option, which can be used to repair objects. Select packages that have the objects to be repaired. This repair operation will replace the existing objects and save the new object types within the same packages.

With use of Where-Used option, you can only check first level of object. Multi-level Object impact or impact due to the change to a table is not directly visible.

With use of Where-used functionality you can easily find this information. Right click on object name → Where-Used

You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query −SELECT "DEPENDENT_OBJECT_NAME" from "SYS"."OBJECT_DEPENDENCIES" WHERE "BASE_SCHEMA_NAME"  = 'AF_HANA' AND "BASE_OBJECT_NAME" = 'STORE' AND "DEPENDENT_OBJECT_NAME" like '%hier%';

You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query and this will show you list of all tables in a schema.Select distinct BASE_OBJECT_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like 'AF_HANA';AH_HANA- Schema name

This can be checked using below SQL query and it will display all system schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like ‘_SYS%’;

This can be checked using below SQL query and it will display all the available schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES"