Map Components in SAP Dashboard Design
SAP Dashboard Design software provides a large number of map components for all the continents and certain countries as well. The Map components link the geographical region shown in the map image to the data with the help of region keys. For example the image below displays the region keys for the different countries of Africa. The Region keys can be modified to match the keys used in the data. This link between Region Keys and data is used to create sensitivity to mouse movement over the map to changes data for a chart component corresponding to the map.
Creation of Region Keys for Custom Map
Sometimes we may require displaying the map of a region that is not present by default in Xcelsius. In this blog we shall consider displaying sales-data for a country called Neverland, which is divided into 3 states: Ever, WhenEver and ForEver.
In the sales-data the regions Ever, WhenEver and ForEver are referred as E, WE and FE respectively. So we start by creating the following mapping in Excel. This will serve the same purpose as Region Keys mapping in default map components.
Creation of the Custom Map
To create the map – Insert a Image component on the canvas and make its size the same as the map you want to display. Go to the general properties of the image component and click on the “Import” button to import the gif image of Neverland.
Insertion of Icons to create mouse-sensitivity
Once the map is created, insert Icon components to indicate each region in the map. Resize the Icon components such that they cover the maximum area of each region.
Modifications on the icons
Each of the icons will insert the region key for that region for the “Mouse-Over” event for that icon. For example, let the green region represent the state Ever. So, for the mouse –over event, This icon will copy the contents of D12 to B4.
The following properties need to be changed for the icon to achieve the above:
In General Properties , change the source data to C12:D12 and the destination to B4.
In Behavior tab, change the Insertion Options to Insert On – Mouse Over.
Make similar changes to the other 2 icons. The icon on the orange region is supposed to insert the contents of D13 to B4 on the mouse over event. The icon on the blue region is supposed to insert the contents of D14 to B4 on the mouse over event.
For each of the icons , go to the Appearance tab and make the transparency 100% so that they are not visible in the final dashboard. Move to the Text tab in Appearance and un-check the check boxes for Mouse-Over Label and Mouse –Over Value.
Creation of the dependent chart
Insert a Line chart. This chart will display the data for the region when the mouse is moved over that region.
Let the data exist in the region B5 : G8 , with the row 5 being the header row. The icon properties have been modified such that whenever the mouse is over a certain region in the image control, the code( E/FE/WE) will be copied to B4.The line chart properties are set such that it will take data from C4:G4 and labels for such data from C5: G5.
In the next section we will give details of how to write excel formula to copy the contents of the correct row to c4:G4.
Formula in Excel
We can use the VLOOKUP formula of Excel to fetch the data of the correct region to C4 :G4.
In the cell C4, we write the following formula =VLOOKUP(B4,B6:G8,2). This will fetch the 2ndcolumn from the data region B6: G8 when the value of B4 matches the 1stcolumn of the data region. This means, if the icons put the value “E” in B4, then this formula will fetch the value 400 to C4.
Using the same logic, formulae written in D4, E4, F4, and G4 are as follows:
D4 : =VLOOKUP(B4,B6:G8,3)
E4: =VLOOKUP(B4,B6:G8,4)
F4: =VLOOKUP(B4,B6:G8,5)
G4: =VLOOKUP(B4,B6:G8,6)
Running the dashboard
Click on the Preview button to see how the application runs.
You will see that the line chart will be modified whenever the mouse moves over a certain region.
1 Comment
