Show TOC

Generating an SAP Business Suite Data Dictionary to HANALocate this document in the navigation structure

PowerDesigner can help you prepare a HANA table structure to allow consolidated reporting on one or more SAP Business Suite installations.

Context


Business Suite to HANA

Procedure

  1. Create a PDM for each SAP Business Suite installation, and import the logical tables that you want to define warehouse reporting on (see Importing an SAP Business Suite Data Dictionary).
  2. Analyze and purify your models, deleting components, packages, tables, and columns that are not of interest to your reporting project.
    Note You should not edit the properties of Business Suite objects (except for the Comment field or Definition tab) or create new objects, in order to ensure the integrity of the metadata that will be generated to the HANA schema.
  3. Select a model to act as the core warehouse model, and then select Start of the navigation path Tools Next navigation step Merge Models End of the navigation path and merge the other models into it one after the other to create a superset of all the components, packages, tables, and columns that you want to generate to HANA.
    For detailed information about merging models, see Core Features Guide > Modeling with PowerDesigner > Comparing and Merging Models.
  4. Select Start of the navigation path Tools Next navigation step SAP Business Suite Next navigation step Generate HANA Physical Data Model End of the navigation path.
  5. Select whether you want to Preserve package hierarchy, which is the default mode, and will recreate the Business Suite component and package structure to the HANA PDM. Note that this structure does not represent HANA packages. Deselecting this option will suppress the creation of these packages and will generate all your tables to the new PDM root. In both cases, your tables will all be exported to the HANA catalog.
  6. Click OK to begin the generation.
    PowerDesigner generates a new PDM targeting the HANA DBMS.
    Note PowerDesigner generates the Business Suite component and package structure to the HANA PDM.
  7. Export your tables to your HANA server (see Exporting Objects to the HANA Repository).
    Implement loading of your transactional data to your HANA warehouse using your standard ETL solution.