Import Data

Objective

After completing this lesson, you will be able to import the data into the model.

Having created our model structure we can now import some data to populate it. In this instance we will do this from a CSV file, but other data sources could also be used.

Note

If you are doing this as a standalone module, download

Now we are ready to import our data.

From within your model select the Data Management workspace.

Under Import Jobs select the Import Data icon.

In the Select a data source drop-down that appear, select the File (Local File or File Server).

Select the Select Source File button.
Select the file Data_PnL_Actual.txt from the Datasets folder.
Select Import.

Select the import job in the table and select Set Up Import.

On the Prepare Data screen, In the Overview section, there are 62 issues related to the value SignedData.

Select the clickable link 62 issues to display the cause.

Set the Data Type field to Number to resolve the issues. You will get confirmation that it has been successfully changed and no issues detected.

Select Next to proceed to the next screen.

You are now in the Map to Facts screen. Here you can map the remaining columns. Drag and drop the following values from Source Columns to Unmapped:

ENTITY to Organisation
PRODLINE to Products
SIGNEDDATA to Measure_AdminXXX

Note

SAP Analytics Cloud analyses your imported data and automatically assigns the columns as either dimensions or measures. Check that your column types are designated correctly and correct any errors that have been detected.

The following screen is displayed:

Select Next.
The following screen allows you to review the mapping properties. Select Next to validate the data.

Once the data is validated, a confirmation message will appear. Select Run Import to import the validated data.

Review the model settings and select Finish to import the data.

Note

While the import is running, the following is displayed:

Note

Once complete, the following screen is displayed, providing information about the status of the import and the number of rows imported.

Having created our model structure we can now import some data to populate it. In this instance we will do this from a CSV file, but other data sources could also be used.

Note

If you are doing this as a standalone module, download

Now we are ready to import our data.

From within your model select the Data Management workspace.

Under Import Jobs select the Import Data icon.

In the Select a data source drop-down that appear, select the File (Local File or File Server).

Select the Select Source File button.
Select the file Data_PnL_Actual.txt from the Datasets folder.
Select Import.

Select the import job in the table and select Set Up Import.

On the Prepare Data screen, In the Overview section, there are 62 issues related to the value SignedData.

Select the clickable link 62 issues to display the cause.

Set the Data Type field to Number to resolve the issues. You will get confirmation that it has been successfully changed and no issues detected.

Select Next to proceed to the next screen.

You are now in the Map to Facts screen. Here you can map the remaining columns. Drag and drop the following values from Source Columns to Unmapped:

ENTITY to Organisation
PRODLINE to Products
SIGNEDDATA to Measure_AdminXXX

Note

The following screen is displayed:

Select Next.
The following screen allows you to review the mapping properties. Select Next to validate the data.

Once the data is validated, a confirmation message will appear. Select Run Import to import the validated data.

Review the model settings and select Finish to import the data.

Note

While the import is running, the following is displayed:

Note

Once complete, the following screen is displayed, providing information about the status of the import and the number of rows imported.

Next lesson