SAP Analytics Cloud Planning – Converting Unit of Measure – Illustrated configuration example
This blog has been inspired by the requirement of a customer to convert its quantity measure into different Units of Measure (UoM).
This blog presents an example on how to configure this specific type of “conversion”.
Please note that this illustrated example is a workaround (with limitations) providing a solution to our customers until the release of a dedicated feature in the future.
For more information and updates, please check out our Roadmap SAP Analytics Cloud Roadmap Explorer
The customer wants to convert sold Daily doses into distributed Package and amounts of Active Ingredients.
Two options are available, one using the Currency conversion inbuild capability of SAP Analytics Cloud, another using the data actions and storing the calculation on another measure.
This blog illustrates the first option.
The end user wants to know on the fly, when planning the quantity of one SKU sold, how many packages will to be distributed and how many active ingredients are requested for the production .
The data input uses the measure Quantity to store the planned Daily doses.
Configuration in SAP Analytics Cloud
This example was developed using the New model, the Currency conversion table and the Currency conversion calculations in the story.
Outcome (in the story)
The business user of the BU1 plans to sell in 2023 1000 daily doses of the product SKU3,
One dose corresponds to 15 gr of active ingredients and 100 doses correspond to 1 distributed package.
Activate the currency conversion in the Preferences of the New model.
Add a Currency property in the SKU dimension
Currency conversion table
Populate the currency conversion table.
Please note that the standard of the IDs is 3 characters as the table relies on the Currency ISO code.
The story calculations generate on the fly the number of packages to be distributed and the number of active ingredients requested to produce those planned daily doses.
Create the measure calculation to convert Daily doses into Packages
Create the measure calculation to convert Daily doses into Active Ingredients grams
This example can be adapted with several SKUs but not with thousands as the configuration effort would be too cumbersome.
See below adaptations to be done to the first configuration in order to convert several SKUs.
In order to differentiate the conversion rate per SKU, use the Specific rate and the rate version.
In my example, I decided to use the SKU to name the rate version but there isn’t any relationship or check within SAP Analytics cloud with the dimension members.
It’s just a naming convention that helps me when configuring.
Calculation conversion from Daily doses to Active Ingredients for the SKU4
Calculation conversion from Daily doses to Packages for the SKU4
Please note that when configuring, nothing prevents you in SAP Analytics Cloud to combine in the story the conversion specific to SKU4 with another SKU, so please check and test carefully your configuration.
SAP Analytics Cloud Planning – New model and conversion steps in data actions- Illustrated configuration example – How to detail impacts of quantity, price and currency rates per SKU and per Transaction Currency | SAP Blogs