- Information
- AI Chat
How to Geo Enrich the Model
Using Dashboards
Subject
Computer Science
835 Documents
Students shared 835 documents in this course
Level
Standard
Academic year: 2020/2021
Uploaded by:
0followers
5Uploads
0upvotes
Recommended for you
Preview text
How to Geo Enrich the Model
Context
The model SAP__FI_CA_IM_OVERDUEBPGEO is delivered as an example with geocoded
data pertinent to the delivered sample data set. You need to manually create your own
SAP__FI_CA_IM_OVERDUEBPGEO model, as a derivative of model
SAP__FI_CA_IM_OVERDUEBP, by injecting your own geo coding information. Perform the
below steps:
Procedure
In Excel:
1. Create a table with headers CustomerPCodeGeo, Description, Latitude, Longitude, Time,
and Measure.
2. Manually enter the values for each column.
Description: The City name corresponding to these postal codes.
Latitude: The latitude corresponding to these postal codes.
Longitude: The longitude corresponding to these postal codes.
Time: The Start Date and the End Date for the analysis in model
SAP__FI_CA_IM_OVERDUEBPGEO. You only need to enter these 2 distinct
values across all rows.
Measure: A value to set a measure for the model. For example, enter “1” for all
rows.
The result looks like the screenshot below.
In SAP Analytics Cloud:
3. Create a new model.
4. Select Import a file from your computer.
5. Upload the newly created Excel table as a CSV file.
6. This brings up the Data Integration screen.
7. Set the metadata for the imported CustomerPCodeGeo, Description, Latitude and
Longitude headers.
8. Set CustomerPCodeGeo as Dimension.
9. Add Description header as Description attribute.
10. Add Latitude header as Property Attribute.
11. Add Longitude header as Property attribute.
12. Select Geo by Coordinate.
14. Click on Create.
15. Set the metadata for the other imported headers.
Time: Set as Time Dimension.
Measure: Set as Measure.
The result is displayed in the screenshot below.
16. Click on MODEL INFO.
17. Name the model SAP__FI_CA_IM_OVERDUEBPGEO.
18. Set the Description to SAP Finance: Contract Accounts Overdue w/ Business Partner and
Geo Data.
Was this document helpful?
How to Geo Enrich the Model
Subject: Computer Science
835 Documents
Students shared 835 documents in this course
Level:
Standard
Was this document helpful?
How to Geo Enrich the Model
Context
The model SAP__FI_CA_IM_OVERDUEBPGEO is delivered as an example with geocoded
data pertinent to the delivered sample data set. You need to manually create your own
SAP__FI_CA_IM_OVERDUEBPGEO model, as a derivative of model
SAP__FI_CA_IM_OVERDUEBP, by injecting your own geo coding information. Perform the
below steps:
Procedure
In Excel:
1. Create a table with headers CustomerPCodeGeo, Description, Latitude, Longitude, Time,
and Measure.
2. Manually enter the values for each column.
Description: The City name corresponding to these postal codes.
Latitude: The latitude corresponding to these postal codes.
Longitude: The longitude corresponding to these postal codes.
Time: The Start Date and the End Date for the analysis in model
SAP__FI_CA_IM_OVERDUEBPGEO. You only need to enter these 2 distinct
values across all rows.
Measure: A value to set a measure for the model. For example, enter “1” for all
rows.
More from:Computer Science
More from:
Computer Science
835 Documents
- More from:Computer Science835 Documents
