Exporting Objects to the HANA Repository

While HANA tables are generated directly to the catalog, analytic and attribute views are exported to the HANA repository from where they will be deployed. PowerDesigner provides a wizard to allow you to export your views and tables to the HANA repository and catalog respectively in a single action.

Note: This feature requires a 32-Bit Java installation.

In your PDM, the HANA catalog is represented by the root of the model, while the HANA repository is represented by a structure of HANA packages. In order to generate your tables and views correctly, you must place your tables at the root (or in standard PowerDesigner packages), and your facts (analytic views) and dimensions (analytic views) in their appropriate HANA packages.

In the following example, the tables in the Sales Tables physical diagram are at the root of the model, and appear as shortcuts inside the Sales Hana package, which contains the corresponding fact and dimensions:
HANA Export - Model Structure
Tables and analytic and attribute views imported from HANA are automatically placed at the root and in HANA packages as appropriate. When generating cubes from tables in your model (see Generating Cubes), launch the wizard from within a HANA package. If you have generated cubes at the model root, drag the multidimensional diagram into a HANA package to move its contents.

Select Database > Apply Model Changes to HANA Repository to open the wizard, and click Next on the Welcome page.
The wizard checks your model for consistency and displays any errors which may compromise the generation.
Enter your HANA repository host name and instance number, along with your user name and password, and then click Next to connect.
Use the tools to the right of the Connection field to create a new connection profile, review the properties of the existing profile, or delete it. HANA connection profiles are stored in the registry.
Note: The account with which you connect must have at least the CONTENT_ADMIN, MODELING, and PUBLIC roles.
Select HANA packages in your model in the left pane to make their contents available to export. Select the facts to export in the right pane, and then click Next.
When you select a fact to export, its supporting dimensions are automatically selected for import.
Note: If you have previously imported objects from HANA, the archive model helps to determine model changes since that point (see Archive PDMs).
Select the catalog tables to export, and then click Next.
PowerDesigner automatically selects any catalog tables required by the selected facts and dimensions.
Review the objects that will be exported and then click Finish to generate them to the HANA repository.

Note: If PowerDesigner detects conflicts between changes made in the model and changes to the same objects on the server, then a merge dialog (see Core Features Guide > Modeling with PowerDesigner > Comparing and Merging Models) will open to allow you to select, for each conflict, which of the conflicting changes will prevail. The resolutions that you select will first be applied to the model, and then your changes will be exported to the the server.