Define Business Partner Dimension

Select Data Builder in the side navigation area. Choose your space if necessary.

Select the New Graphical View tile, opening the view editor.

In the Repository tab, select the BusinessPartners table and drag it onto the canvas.

On the canvas, the BusinessPartners node is linked with the output node View 1 automatically. The output node represents the final dataset and properties of the model.

Select the output node View 1, and go to the properties side panel on the right.

Enter Business Partner Dimension as the new Business Name.

Don’t change the Release State, as your user doesn’t have sufficient privileges to revert back to the previous state.

Release State is an optional feature. It provides stable objects consumers can use with confidence.

Click here for more information.

Change the Semantic Usage to Dimension.

The Semantic Usage determines how the entity will be used. Dimension indicates that your entity contains attributes that can be used to analyse and categorize measures defined in other entities.

Set Expose for Consumption to ON.

This makes the object available for consumption in SAP Analytics Cloud and other analytical clients.

[Optional] Choose Hide source tree and Zoom to Fit to rearrange the modeling nodes on the canvas, as we don’t add further objects from the source tree panel to the canvas.

Select the BusinessPartners node on the canvas.

Choose the Projection operator in the popup menu, to add it to the diagram.

Select the Projection node that was added.

In the properties panel, select the More (…) button for BW Delta Process: Update Mode, and choose Exclude Column.

Select the output node Business Partner Dimension on the canvas.

In the properties panel, scroll down to the Associations section.

Select the Create Association ‘+’ button, and choose Association.

In the Select Association Target dialog, choose Address Dimension (Technical Name) and press the Select button. (If you choose the Business Name link, the object editor opens in a new tab).

Review the Mappings section. An automatic mapping is done for matching column names.

• Ensure that the ADDRESSID column of the Business Partner Dimension is joined to the ADDRESSID column of Address Dimension.

Select the More downward chevron to the left of the slash in the header area, and select the Business Partner Dimension entry.

This should return you to the Associations section in the properties panel.

In the properties panel, go to Attributes section and select the Edit Columns pencil icon.

Apply the following changes:

• Set Semantic Type of attribute COMPANYNAME to Text.
• Set Text/Association of attribute PARTNERID to COMPANYNAME.

The semantics will enhance the data model we are going tp build in the next lessons. For example, instead of the value of PARTNERID, the associated text of COMPANYNAME will be displayed in the analysis screen.

Close the attributes editor.

Your view diagram and dimension properties will look like the following:

Select the output node Business Partner Dimension in the canvas, and choose the Data Viewer operator, to display the values in the preview window below.

Select the Deploy icon in the header menu.

Confirm the Business name as Business Partner Dimension, and Save it.

Notification messages appear and inform you on the deployment progress.

Ensure the view is deployed before you continue.

After the successful deployment, go to the Data Persistence section in the properties panel.

Select the Data Persistence icon, and choose Start Data Persistence. If asked, confirm the action in the dialog popup.

Select the Refresh icon, to track the persistence progress.

[Optional] Open the Views Monitor link. There, you can monitor the run details inside the Data Integration Monitor.

In the Data Integration Monitor, select the Back ‘<’ symbol in the shell bar (top bar), or choose the Open in Data Builder icon, to return to the view editor.

Close the graphical view editor and return to the Data Builder entry site.

Select Data Builder in the side navigation area. Choose your space if necessary.

Select the New Graphical View tile, opening the view editor.

In the Repository tab, select the BusinessPartners table and drag it onto the canvas.

On the canvas, the BusinessPartners node is linked with the output node View 1 automatically. The output node represents the final dataset and properties of the model.

Select the output node View 1, and go to the properties side panel on the right.

Enter Business Partner Dimension as the new Business Name.

Don’t change the Release State, as your user doesn’t have sufficient privileges to revert back to the previous state.

Release State is an optional feature. It provides stable objects consumers can use with confidence.

Click here for more information.

Change the Semantic Usage to Dimension.

The Semantic Usage determines how the entity will be used. Dimension indicates that your entity contains attributes that can be used to analyse and categorize measures defined in other entities.

Set Expose for Consumption to ON.

This makes the object available for consumption in SAP Analytics Cloud and other analytical clients.

[Optional] Choose Hide source tree and Zoom to Fit to rearrange the modeling nodes on the canvas, as we don’t add further objects from the source tree panel to the canvas.

Select the BusinessPartners node on the canvas.

Choose the Projection operator in the popup menu, to add it to the diagram.

Select the Projection node that was added.

In the properties panel, select the More (…) button for BW Delta Process: Update Mode, and choose Exclude Column.

Select the output node Business Partner Dimension on the canvas.

In the properties panel, scroll down to the Associations section.

Select the Create Association ‘+’ button, and choose Association.

In the Select Association Target dialog, choose Address Dimension (Technical Name) and press the Select button. (If you choose the Business Name link, the object editor opens in a new tab).

Review the Mappings section. An automatic mapping is done for matching column names.

• Ensure that the ADDRESSID column of the Business Partner Dimension is joined to the ADDRESSID column of Address Dimension.

Select the More downward chevron to the left of the slash in the header area, and select the Business Partner Dimension entry.

This should return you to the Associations section in the properties panel.

In the properties panel, go to Attributes section and select the Edit Columns pencil icon.

Apply the following changes:

• Set Semantic Type of attribute COMPANYNAME to Text.
• Set Text/Association of attribute PARTNERID to COMPANYNAME.

The semantics will enhance the data model we are going tp build in the next lessons. For example, instead of the value of PARTNERID, the associated text of COMPANYNAME will be displayed in the analysis screen.

Close the attributes editor.

Your view diagram and dimension properties will look like the following:

Select the output node Business Partner Dimension in the canvas, and choose the Data Viewer operator, to display the values in the preview window below.

Select the Deploy icon in the header menu.

Confirm the Business name as Business Partner Dimension, and Save it.

Notification messages appear and inform you on the deployment progress.

Ensure the view is deployed before you continue.

After the successful deployment, go to the Data Persistence section in the properties panel.

Select the Data Persistence icon, and choose Start Data Persistence. If asked, confirm the action in the dialog popup.

Select the Refresh icon, to track the persistence progress.

[Optional] Open the Views Monitor link. There, you can monitor the run details inside the Data Integration Monitor.

In the Data Integration Monitor, select the Back ‘<’ symbol in the shell bar (top bar), or choose the Open in Data Builder icon, to return to the view editor.

Close the graphical view editor and return to the Data Builder entry site.