SAP HANA Modeling

SAP HANA Modeling:-

We will create new data model or modify existing data model using by SAP in-memory computing studio. Once you created these data models used to create multiple views of transactional data that can be used for analytical purpose.

How to source system meta data import:

Here we will import tables definitions from source system to target system. physical tables are created dynamically.

1. Schema's:- you need to create the schemas for import all the required table.

2. Mass Import of Meta data:- here will import all tables definitions from SAP ERP to SAP in-memory computing studio.

 * How to import all tables: In studio select File menu, then choose Import
                                               => Information modeler
                                               => Mass import source objects
                                               => next
                                               => select target system location to import table definitions
                                               => next
                                               => in the connection details window give the USER ID & PW.                                                => Finish.

* Selective Import Metadata: Selected tables only import using by Data Services.

 * How to import selected tables: File menu, then choose Import
                                                         => Information modeler
                                                         => source objects
                                                         => next
                                                         => select target system where we want import metadata.
                                                         => select source system (choose the connection)
                                                         => choose object type to import
                                                         => next
                                                         => give the table name for search
                                                         => select table and Add in the created schema
                                                         => next
                                                         => validate object properties
                                                         => finish.