Forecast

Objective

After completing this lesson, you will be able to to import the forecast

Based on what we have learned in the previous chapters we can create or modify the financial forecast which is an estimate of future financial outcomes for a company.

At present our model only has Actual data stored within it - we need to add some Forecast data which we will get from a CSV file.

Import Forecast Data

Before we import the data, we need to manually add Forecast to the Version dimension.

Navigate to Main Menu > Files > My Files.
Select Model PnL_Admin_New.
In the Model Structure Workspace, select the Edit Dimension Table button mext to Version

In the toolbar under Edit select the Add (+) button.

Add the following values to the new row in the table:
- Description: Forecast
- Category (select from the drop-down that appears): Forecast

Select the Save icon to save the changes.

Select the back arrow to return to the Model Structure.

Note

If you are doing this as a standalone module, download

Select the Public folder. Select the Experience Academy - SAC Planning folder and then the Datasets folder and select the file to download.

Select Data Management from the Workspace drop-down and then select the Import Data button.

Select the File (Local File or File Server) option from the list.

Click the Select Source File button, then select the file Data_PnL_Forecast.txt from the location that you have downloaded your datasets to. Then select Import.

Wait for this confirmation message:

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

In the Prepare Data screen there are no errors shown, so select Next to proceed to the next screen.

In the Map to Facts screen, we are shown the Source and Target mappings. The first step will be to unmap the Default Value for version, as we need to change it. Select the X beside the Source Default Value that is mapped to Version.

You will see that Version has been added back into the Unmapped section.

In the Source column for Version, select the More (…) icon then Set default value…

Select public.Forecast then OK.

You will get a confirmation message at the bottom of the screen.

You will see that the Default Value mapped to Version is set to public.Forecast. Next 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.

In addition to the Actual and Product Profit data, we have now loaded our original Forecast data to the model.

Based on what we have learned in the previous chapters we can create or modify the financial forecast which is an estimate of future financial outcomes for a company.

At present our model only has Actual data stored within it - we need to add some Forecast data which we will get from a CSV file.

Import Forecast Data

Before we import the data, we need to manually add Forecast to the Version dimension.

Navigate to Main Menu > Files > My Files.
Select Model PnL_Admin_New.
In the Model Structure Workspace, select the Edit Dimension Table button mext to Version

In the toolbar under Edit select the Add (+) button.

Add the following values to the new row in the table:
- Description: Forecast
- Category (select from the drop-down that appears): Forecast

Select the Save icon to save the changes.

Select the back arrow to return to the Model Structure.

Note

If you are doing this as a standalone module, download

Select the Public folder. Select the Experience Academy - SAC Planning folder and then the Datasets folder and select the file to download.

Select Data Management from the Workspace drop-down and then select the Import Data button.

Select the File (Local File or File Server) option from the list.

Click the Select Source File button, then select the file Data_PnL_Forecast.txt from the location that you have downloaded your datasets to. Then select Import.

Wait for this confirmation message:

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

In the Prepare Data screen there are no errors shown, so select Next to proceed to the next screen.

In the Map to Facts screen, we are shown the Source and Target mappings. The first step will be to unmap the Default Value for version, as we need to change it. Select the X beside the Source Default Value that is mapped to Version.

You will see that Version has been added back into the Unmapped section.

In the Source column for Version, select the More (…) icon then Set default value…

Select public.Forecast then OK.

You will get a confirmation message at the bottom of the screen.

You will see that the Default Value mapped to Version is set to public.Forecast. Next you can map the remaining columns. Drag and drop the following values from Source Columns to Unmapped: