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
- 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.
- 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.
- 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.
- Select the Columns tab, and click the Add
Objects tool. Select one or more columns from the data sources
and click OK.
- 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.
- [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.
- Click OK to complete the creation of the calculation
view.
- Export the calculation view to the HANA repository (see Exporting Objects to the HANA Repository).