5 Highlights included in SAP Analytics Cloud content
SAP Analytics Cloud content contains lots of ready-to-run examples featuring the latest technology and highlighting new features. This blogpost will introduce you to 5 highlights of SAP Analytics Cloud content, namely: what-if scenarios, geo maps, smart discovery, currency conversions and planning.
[Last updated: 27th of April 2018, SAP Analytics Cloud Version 2018.5.0]
In SAP Analytics Cloud offers different options to realize what-if scenarios. One of them is to use a calculation input control. This functionality was implemented in the “SAP Chemicals: Digital Boardroom” for Market Analysis. If you do not have a boardroom license, you can simply go to the story “SAP Chemicals: Portfolio – Market Analysis”.
Using the sliders on the left-hand side of the page, you can select a value for Your Company’s Coatings Total Market Share. The total coatings market share is made up of the markets Automotive, Building & Construction and Industrial. When we switch the total market share for 2018 from 8% to 12%, we can see that two charts get affected: “Contribution Margin per Market” and “My Materials Market Share”.
In “Contribution Margin per Market” we can see that the Average Coatings Share per Market increased from 2,7% to 4% and about half of the total market share (12%) comes from the Industrial Market (6%).
In “My Materials Market Share” we can see that the negative impact seen before, can be replaced with strong growth in the top 10 materials, especially for the top 3 materials.
Geo maps were used in a variety of stories. Here is one example how they were used in SAP Environment, Health & Safety, for example in the story “SAP Environment, Health & Safety: Health & Safety – Incidents”.
On the geo map you can see two layers which you can switch off and on. If we inspect only the Country layer, we can see that the number of fatalities have been especially high in plants in Brazil and India. Now, if we switch on the bubble layer, the size of the bubbles indicates the Number of Incidents and the bubble color the number of lost workdays. We can see that in plants in all regions the total number of incidents is relatively evenly distributed but the number of lost workdays is similar as the fatalities disproportionally higher in some plants – similar to the number of fatalities.
In other areas, Smart Discovery was used to gain more insights in the data we are working with. You can find an example in the story “SAP Finance: General – Financial Performance”. Here, we ran a smart discovery to find out what influences Net Revenue.
The Smart Discovery shows us that Customer Group heavily influences Net Revenue but that there is something wrong with our Customer Segmentation as Group B customers have lesser influence than Group C.
There are some models in the SAP Analytics Cloud content that use currency conversion. Here, we will illustrate the example of the model SAP__TE_GEN_IM_EXPENSEENTRY and SAP__TE_GEN_IM_EXPENSEREPORT which is being used in the story SAP__TE_GEN_TRAVELEXPENSE.
Open the Preferences of the model to see how the currency conversion is applied. The currency conversion is based on the table SAP_ALL_CURRENCY.
You can find the currency conversion table by going in Browse > Currencies. With wave 2018.05 currency conversion rates can also be imported from Excel.
When importing data, currency codes are mapped to the Dimension Transaction Currency in SAP__TE_GEN_IM_EXPENSEENTRY and Currency in model SAP__TE_GEN_IM_EXPENSEREPORT. For more information on the mapping, please visit the SAP Analytics Cloud content documentation.
In the story SAP__TE_GEN_TRAVELEXPENSE currency conversion is being used in tables as well as charts. On the page Dynamic, you can use the chart details to convert the chart into different currencies.
On the page Entries per Report, the entries table shows amounts converted from Local Currency to Default currency.
A variety of the SAP Analytics Cloud content uses planning features, for example the SAP Travel and Expense or the SAP Human Resources – Salary Planning.
Notice that in order to edit planning models, a planning license is needed.
In the story “SAP Concur Travel Expenses” Expense Budget Planning on program/project hierarchies can be performed with budget distribution capabilities and tracking of actual vs. budget deviations. By clicking on any budget cell within the table, the budget can be adjusted in the budget column. The values in the table will adjust automatically. In addition, the chart on the right-hand side adjusts automatically responding to the input.
In this example 10000 USD are being added for the Budget in Program A GR-9.
The affected cells are highlighted: The entry added 10000USD to the overall budget for Program A and to the total Budget. In the chart, the delta to budget has increased by another 10000 USD resulting in 27% of the budget still remaining.
Leave us a comment below in case you have any questions or suggestions how content could be improved.
You want to stay up-to-date? Paste this into your RSS feed-reader and subscribe.