Create Business Partner Dimension

Create Business Partner Dimension

Contents

  • Create Business Partner Dimension
  • Add Geo Coordinates Columns
  • Add a Level Based Hierarchy
  • Save and Deploy

We will create a Graphical View of semantic usage Dimension for Business Partner master data, and join it with address data to further enrich our view.

At the conclusion of this lesson your Graphical View will look similar to …

Create Business Partner Dimension

  1. After Logon, click on Data Builder in the navigation menu on the left.

  2. Select your space if necessary.

  3. Click New Graphical View.

  4. Click on Sources.

  5. Expand Connections > HANA_EDW > DWC_DEMO and select table BusinessPartners.

  6. Drag BusinessPartners onto the canvas.

  7. Click Import and Deploy.

    Note: A popup indicating Successful Deployment should show up in a few seconds.

  8. Click Zoom to Fit.

  9. Click on the Output View called View 1.

  10. Change the Business Name to UXX_BusinessPartnerDimension where XX is your group number (01, 02, 03 etc).

  11. Change the Semantic Usage to Dimension.

  12. Verify that Expose for Consumption is set to "ON".

  13. Switch on Run in Analytical Mode.

  14. Now drag and drop the Addresses table from the HANA_EDW source onto BusinessPartners on the canvas.

    Note: Make sure you select JOIN in the popup which shows as you drag Addresses on top of the BusinessPartners table.

  15. Click Import and Deploy on the popup.

Now we want to edit the Attributes of the View, so that we can later use it to display City names in a Geo Map chart.

  1. Click on the Output View called UXX_BusinessPartnerDimension.

  2. In the Attributes section, click on ‘Edit Columns’.

  3. Scroll down and change the Semantic Type of City to ‘Text’.

  4. Scroll up and change the Label Column of Partner ID to ‘City’ by selecting this option in the dropdown.

  5. Deselect the Key selection box for Address ID.

    After joining Business Partners and Addresses the Addess ID as a key is no longer required.

  6. Close the Attributes editor by clicking on Close on the bottom right of the window.

Add Geo Coordinates Columns

Next, we will create a geo-coordinates column to combine latitude and longitude values that can be used in a SAP Analytics Cloud Geo Map.

You can only create geo coordinates in a graphical view with a semantic usage of Dimension.

Review the Help Portal for more information at Creating a Geo-Coordinates Column.

  1. Click the Addresses table to select it.

  2. Click Calculated Columns in the popup menu (context tool).

  3. Hide the source tree and select Zoom to Fit to adapt the canvas.

  4. Click on the new Calculated Columns node which was added to the diagram.

  5. Click on Add a New Calculated Column ‘’+‘’ at the top of the Details panel.

  6. Select Geo-Coordinates Column in the dropdown.

  7. Change the Business Name to BPLocation.

  8. Verify that the LATITUDE and LONGITUDE columns are set correctly.

  9. Click on the Output View node and select Preview Data on the popup.

Add a Level Based Hierarchy

We'll now create a Level Based Hierarchy attached to the BusinessPartners Dimension to support drill-down and drill-up.

Review the Help Portal for more information at Add a Hierarchy to a Dimension.

  1. In the Details of the Output View, click the icon with three folders representing a hierarchy.

  2. Click on Add ‘+’ sign to add a Hierarchy.

  3. And then select Level Based Hierarchy.

  4. Change the Business Name to BPHierarchy.

  5. Click the Add Level ‘’+‘’ sign in the Levels section.

  6. Use the Dropdown to select the REGION column.

  7. Repeat this action - click the Add Level ‘’+‘’ sign, select Country in the new Row of the dialog box.

  8. Repeat for City.

    The Hierarchy has a fixed number of levels and will be structured top-down in the order of the fields you've selected (top of the list to the bottom of the list)

  9. Click Close.

  10. Note the Indicator for the existence of a Hierarchy on the Dimension.

    Only Dimensions can carry hierarchies.

Save and Deploy

When you save an object, it is stored in the SAP Datasphere repository. When you deploy an object, you are creating a run-time version for use in the SAP Datasphere database.

  1. Click Deploy.

  2. In the window popup, confirm the name UXX_ProductDimension where XX is your group number (01, 02, 03 etc.). Click on Save.

  3. Once the View has been successfully deployed, select your space in the menu bar to return to the list of Views in your Space.

Congratulations! You have created a Dimension Graphical View, and enhanced it with a Geo Coordinates column and Level Based hierarchy.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn