Often global companies may report a metric like units sold or volumes in a stat account. But that unit of measure may vary by region or country. Below is one option for handling the conversion of stat accounts like units sold or volumes.
Here are some high level ways to tackle this in an application.
Your conversion rates do not vary over time so you really just need to store these rates once in the application for all time periods:
There are a few different options for storing these conversion rates:
Set up accounts as follows:
Set up entity as follows:
Set up cube as follows: