Skip to Content
Technical Articles
Author's profile photo Charlotte BURNIER

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

 

Use case

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.

 

Design requirements

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.

 

 

Model configuration

 

Activate the currency conversion in the Preferences of the New model.

 

Add a Currency property in the SKU dimension

 

 

Configure the measure “Quantity”, set the currency conversion and link it to the SKU dimension, previously updated with a Currency property.

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.

 

Story configuration

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.

 

Currency table 

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.

 

 

Story

 

Calculation conversion from Daily doses to Active Ingredients for the SKU4

 

 

Calculation conversion from Daily doses to Packages for the SKU4

 

 

 

Story (outcome)

 

 

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.

 

Useful links 

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

 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.