Reading Data from SAP HANA Modelling Views Using PowerCenter

Back Next

Creating a Mapping

After you import the HANA modelling view, create a mapping. In PowerCenter, select a source filter that you configured in SAP and specify the variables or parameters.

Create a mapping.

If you use input parameters, do not connect the input parameters in the Source Qualifier to the output fields. Otherwise, the mapping fails.

To edit the Source Qualifier, click the

Properties

tab in the

Edit Transformations

window.

Click the

icon next to the

Source Filter

field.

The

SQL Editor

page appears.

Select the column view in which you want to apply a filter from the list of column views on the left pane.

Specify the variable name or input parameter name in double quotes. Specify the variable value or input parameter value in single quotes. When you want to specify more than one variable or parameter, separate the variables or parameters using commas.

The following image shows a source filter for a variable value: The view uses a variable COMPANY that has a value of 1000.