Show TOC

Creating a Calculation ViewLocate this document in the navigation structure

PowerDesigner supports creation of calculation views for export to HANA. Simple calculation views with one or two data sources can be designed within PowerDesigner, while more complex calculation views with three or more data sources can be initialized for completion within your HANA modeling tool.

Procedure

  1. Prepare the data sources (tables or standard, attribute, analytic, or other calculation views) for your calculation view in your HANA Database PDM by importing them from HANA, generating from a CDM or LDM, or creating them directly in the model.
    Note To create calculation views consuming HDI artifacts, you must import activated tables from the HANA catalog into your HANA Database PDM.
  2. Open a HANA package diagram, select the Calculation View tool in the toolbox, and click in the diagram.
    Note You can only create calculation views under a HANA package.
  3. Open its property sheet, select the Data Sources tab, and click the Add Objects tool to select tables, views, or calculation views as sources for the view and click OK.
    If you select:
    • One or two data sources - You can design the calculation view in PowerDesigner and load and activate it directly in HANA.
    • Three or more data sources - You can initialize the definition of the calculation view in PowerDesigner and load it for completion in your HANA modeling tool.
  4. Select the Columns tab, and click the Add Objects tool. Select one or more columns from the data sources and click OK.
  5. Select a column as the measure, by selecting its checkbox in the M[easure] column.
    Note If the M[easure] column is not visible, click the Customize Columns and Filter tool to add it.
  6. [optional] Select the Source Columns tab, and click the Add Objects tool to specify columns that are implicated in the definition of the calculation view so that they are included in impact analyses. Select one or more columns from the data sources for the view and click OK.
  7. Click OK to complete the creation of the calculation view.
  8. Export the calculation view to the HANA repository (see Exporting Objects to the HANA Repository).