Skip to Content
Technical Articles
Author's profile photo Sumin Lee

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)

Upload%20dataset

Upload dataset

Step2: Change dataset with Geo Enrich By: Coordinates

Please select latitude and longitude and click coordinates

Click

Geo Enrich By Coordinates

Step3: Create new dimension by Location with Coordinates

You can create new Dimension for location with latitude and longitude.

Location

Create new dimension

 

Step4: Check the new dimension as a Location

You can check the new dimensions, “Location” as a dimension.

Check%20the%20new%20dimension%20as%20a%20Location

Check the new dimension as a Location

 

Step5: Change dimension properties: Description by Country

You can change the dimension properties by description.

Change%20dimension%20properties-Description

Change dimension properties-Description

But! Without description setting, the data in geo map shows as below with Latitude and Longitude information.

Without description 

Here is a map chart with descriptions of country information, which is our target geo map.

With%20Description%20-%20countryWith Description – country

 

Step6: Create story for Geo Map

Add data and add an Geo Map to the story canvas.

Create%20story%20for%20geomap

Create story for geo map

 

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.

Add%20layers

Add layers

Base%20Layer

Base Layer

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.

Add

Add location dimension

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.

Bubble%20size

Set bubble size

Step10: Adjust Bubble Size

For the Result measure, you can adjust the bubble size and range scale as follows:

Adjust%20bubble%20size

Bubble size and range scale

 

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.

Bubble%20color

Bubble color of a measures or dimensions

Change%20color

Set palette

Change%20range

Set ranges

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.

Set%20filters

Set filters

You can set a filter for “Process” and members are included or excluded.

Include/Exclude%20values

Include/Exclude members

You can check Process A, B, C selected in the Layer Builder filter.

filters

Check selected members

Additionally, in the geomap chart, you can check the selected filters. When you click the Edit Filter, you can set the filters.

Set%20filters%20in%20the%20canvas

Set filters in the canvas

When setting additional filters for the ‘Region’ dimension, you can see additional filters as shown below.

Location%20filters

Location filters for Region dimension

 

Step13: Input control

You can also set the input control at the page filter level.

Input%20control

Add Input control

Please select page filter by dimensions or measures. This example sets a filter on the “Process” dimension.

Input%20control%20setting

Set Input control for dimensions or measures

Please set filters for the Process dimension

Process

Set Filters for Process

You can check the Input control for the Process.

Check%20the%20input%20control

Check the input control by process filter

 

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.

Filter%20setting%3A%20layer%20builder%20vs.%20Input%20control

Filter setting: layer builder vs. Input control

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

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

 

 

Learn more about SAP Analytics Cloud

  • Want to play around with SAP Analytics Cloud yourself? Download a trial version here
  • Locate the “?” symbol on the top of your SAP Analytics Cloud window to access the help documents, including guided playlistsknowledge basebrowse community, etc.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo hunters drift
      hunters drift

      Thank you very much for this itinerary information. it really makes sense to me.

      Author's profile photo Sumin Lee
      Sumin Lee
      Blog Post Author

      Thanks for your comments! I hope my travel itinerary is helpful to readers.