Direct Data Upload

Objective

After completing this lesson, you will be able to create a local table for country specific data and upload CSV data directly.

Contents

  • Create local table
  • Maintain table and attribute semantics
  • Upload data from CSV file

In this section, we create a table with country-related information for our data model. The data for the table is uploaded from a CSV file. Afterwards, we change the default relational semantic of the table to Dimension.

In general, you can create and import empty tables and views to receive and prepare data:

  • You can create an empty local table ready to receive data from a CSV file or from a data flow.
  • You can import business content prepared by SAP and partners to support end-to-end business scenarios.
  • You can import object definitions from a CSN/JSON file.

Create local table

For this modeling step we will create a table, maintain the columns and their data types. For this task, you use the Data Builder to create a new table.


  1. Select Data Builder in the side navigation area, choose your space if necessary.

  2. Select the New Table tile to open the table editor.

You are being presented with the details to create a new table.

  1. Enter the following details:

    • Business Name: Countries
    • Technical Name: Countries

  1. Scroll down to the Columns section (or select the tabs in the page header for navigation). Here now you define the structure of the table by adding the individual columns.

  2. Use the “+” sign in the top right corner of the Columns area to start the process of creating your first table column.

    You need to enter a Business Name, a Technical Name, and you need to configure the Data Type.

  1. For the first column, enter the following details:

    • Business Name: COUNTRYCODE
    • Technical Name: COUNTRYCODE
    • Data Type: String(5)

    You can change the data type by pressing the item in the Data Type column.

After you entered the details for the first column, insert the two additional columns. All columns of the table are listed as follows:

Key: Business Name: Technical Name: Data Type:
X COUNTRYCODE COUNTRYCODE String(5)
X LANGUAGE LANGUAGE String(2)
COUNTRYTEXT COUNTRYTEXT String(50)

  1. Ensure you enable the Key Column option for the columns COUNTRYCODE and LANGUAGE.

  2. Your table columns and key column setting should look like:

Maintain table and attribute semantics

This table becomes a dimension entity to enhance the data model. In the next steps, we change the semantic type for the table as well as for columns. Additionally, we add a label for the country description.

  1. Update the table and attribute settings:

    • Change Semantic Usage to Dimension
    • Set Semantic Type of attribute LANGUAGE to Language
    • Set Semantic Type of attribute COUNTRYTEXT to Text
    • Set Text/Association Column of attribute COUNTRYCODE to COUNTRYTEXT

In the next steps save and deploy your table.

  1. Select the Deploy icon in the header menu.

  2. Confirm the business and technical name Countries in the pop-up window and save it.

  3. A notification message appears about the successful deployment.

Upload data from CSV file

You populate the created table, so that we have data for the analysis.

  1. Download the COUNTRIES.CSV file and save it locally.

  2. Select Upload Data from CSV File icon in the top toolbar.

  1. Select the Choose File icon in the Import CSV File window popup.

  2. Select the COUNTRIES.CSV file, which you have downloaded before.

  3. In the Import CSV File wizard, verify the settings:

    • Ensure the 'Delete Existing Data Before Upload’checkbox is marked
    • Ensure the ‘Use first row as column header’ checkbox is marked
    • Ensure that all columns of the table have a mapped column from the CSV File

  1. Press the Import button.

  2. A notification message appears about the successful import.

  3. Select the Data Viewer icon to check if the data was loaded into the table.

  4. Select Data Editor in the toolbar (top right), to enter the EDIT mode.

  5. The Data Editor offers to update values and add, delete or duplicate records.

  6. Close the table again.

What was done ?

In this step, we created a local table and changed the table semantic as well as the column attributes semantics. Finally, we imported data from local stored CSV file. The table represents a dimension with country-related information for our data model.


Contents

  • Create local table
  • Maintain table and attribute semantics
  • Upload data from CSV file

In this section, we create a table with country-related information for our data model. The data for the table is uploaded from a CSV file. Afterwards, we change the default relational semantic of the table to Dimension.

In general, you can create and import empty tables and views to receive and prepare data:

  • You can create an empty local table ready to receive data from a CSV file or from a data flow.
  • You can import business content prepared by SAP and partners to support end-to-end business scenarios.
  • You can import object definitions from a CSN/JSON file.

Create local table

For this modeling step we will create a table, maintain the columns and their data types. For this task, you use the Data Builder to create a new table.


  1. Select Data Builder in the side navigation area, choose your space if necessary.

  2. Select the New Table tile to open the table editor.

You are being presented with the details to create a new table.

  1. Enter the following details:

    • Business Name: Countries
    • Technical Name: Countries

  1. Scroll down to the Columns section (or select the tabs in the page header for navigation). Here now you define the structure of the table by adding the individual columns.

  2. Use the “+” sign in the top right corner of the Columns area to start the process of creating your first table column.

    You need to enter a Business Name, a Technical Name, and you need to configure the Data Type.

  1. For the first column, enter the following details:

    • Business Name: COUNTRYCODE
    • Technical Name: COUNTRYCODE
    • Data Type: String(5)

    You can change the data type by pressing the item in the Data Type column.

After you entered the details for the first column, insert the two additional columns. All columns of the table are listed as follows:

Key: Business Name: Technical Name: Data Type:
X COUNTRYCODE COUNTRYCODE String(5)
X LANGUAGE LANGUAGE String(2)
COUNTRYTEXT COUNTRYTEXT String(50)

  1. Ensure you enable the Key Column option for the columns COUNTRYCODE and LANGUAGE.

  2. Your table columns and key column setting should look like:

Maintain table and attribute semantics

This table becomes a dimension entity to enhance the data model. In the next steps, we change the semantic type for the table as well as for columns. Additionally, we add a label for the country description.

  1. Update the table and attribute settings:

    • Change Semantic Usage to Dimension
    • Set Semantic Type of attribute LANGUAGE to Language
    • Set Semantic Type of attribute COUNTRYTEXT to Text
    • Set Text/Association Column of attribute COUNTRYCODE to COUNTRYTEXT

In the next steps save and deploy your table.

  1. Select the Deploy icon in the header menu.

  2. Confirm the business and technical name Countries in the pop-up window and save it.

  3. A notification message appears about the successful deployment.

Upload data from CSV file

You populate the created table, so that we have data for the analysis.

  1. Download the COUNTRIES.CSV file and save it locally.

  2. Select Upload Data from CSV File icon in the top toolbar.

  1. Select the Choose File icon in the Import CSV File window popup.

  2. Select the COUNTRIES.CSV file, which you have downloaded before.

  3. In the Import CSV File wizard, verify the settings:

    • Ensure the 'Delete Existing Data Before Upload’checkbox is marked
    • Ensure the ‘Use first row as column header’ checkbox is marked
    • Ensure that all columns of the table have a mapped column from the CSV File

  1. Press the Import button.

  2. A notification message appears about the successful import.

  3. Select the Data Viewer icon to check if the data was loaded into the table.

  4. Select Data Editor in the toolbar (top right), to enter the EDIT mode.

  5. The Data Editor offers to update values and add, delete or duplicate records.

  6. Close the table again.

What was done ?

In this step, we created a local table and changed the table semantic as well as the column attributes semantics. Finally, we imported data from local stored CSV file. The table represents a dimension with country-related information for our data model.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn