Beginner’s SAP Analytics Cloud Journey: Day3
Dear SAP Analytics Cloud beginners,
This is a blog post for beginners in SAP Analytics Cloud. I also started learning SAP Analytics Cloud from August 2021. I’d like to share my trial and error from a beginner’s point of view, and hope it helps you get started easily!
Day3: Geo map chart
I posted a blog “Datatype and data transform” before creating a chart. (Link to Beginner’s SAP Analytics Cloud Journey: Day2)
A geo map chart to show a map of a country or region map with colors, sizes and values assigned to a specific area. Today we will create a geo map chart and please follow the steps🙂
Step1: Upload dataset
This dataset includes geo information with latitude, longitude and country.
- Dimensions: Process, Country, Region
- Measures: Latitude, Longitude, Result(random number by country level)
Step2: Change dataset with Geo Enrich By: Coordinates
Please select latitude and longitude and click coordinates
Step3: Create new dimension by Location with Coordinates
You can create new Dimension for location with latitude and longitude.
Step4: Check the new dimension as a Location
You can check the new dimensions, “Location” as a dimension.
Step5: Change dimension properties: Description by Country
You can change the dimension properties by description.
But! Without description setting, the data in geo map shows as below with Latitude and Longitude information.
Here is a map chart with descriptions of country information, which is our target geo map.
Step6: Create story for Geo Map
Add data and add an Geo Map to the story canvas.
Step7: Add Map Layers
In the Builder section, we can add map layers and change the different types of basemap such as Streets, light gray and hybrid.
Step8: Set Location Dimension
We previously created the new location dimension,”Location” in the dataset (step3), and please click the Location as location dimensions in the layer builder.
Step9: Set Bubble Size
You can set the bubble size as a unit of measure in the layer builder. In this example, we will set the “Result” measure.
Step10: Adjust Bubble Size
For the Result measure, you can adjust the bubble size and range scale as follows:
Step11: Set Bubble Color
The bubble color of a measure or dimension can be changed according to your preference. In this example, “Result” measure is selected.
Step12: Set filters
In the Layer Builder, you can set filters at the layer level by location, process, or region dimensions.
In this example, the “Process” dimension has been selected.
You can set a filter for “Process” and members are included or excluded.
You can check Process A, B, C selected in the Layer Builder filter.
Additionally, in the geomap chart, you can check the selected filters. When you click the Edit Filter, you can set the filters.
When setting additional filters for the ‘Region’ dimension, you can see additional filters as shown below.
Step13: Input control
You can also set the input control at the page filter level.
Please select page filter by dimensions or measures. This example sets a filter on the “Process” dimension.
Please set filters for the Process dimension
You can check the Input control for the Process.
Questions) Then what is the difference between the filter in the layer builder and the input control?
Filter level is different as follows:
- Filters in the layer builder are at the geo map chart layer level.
- Filters in the input controls are at the page filter level.
Higher priority is Set Filters in the layer builder setting (Step11). The filter settings on the Input Control page are affected by the filter settings in the Layer Builder.
For example, geo map doesn’t show I, J, K data, because filter in the layer builder only includes A, B, C process.
Step14: Check the Geo map chart
Now you can now create Geo map chart👏👏👏!
Geo map charts are great for visualizing datasets at the geographic level. And please don’t forget to check your dataset before creating a geo map chart.
Result of geo map chart
If you’d like to learn more about charting and analyzing time series data? Please refer to my blog postings:
Following on Beginner’s SAP Analytics Cloud Journey: Day4 – How to create chart with selected measures