Currencies by Subsidiary helps you plan and report in local currencies across subsidiaries, while keeping your parent-level rollups accurate and consistent. This is especially useful for customers using ERPs like NetSuite, where different exchange rates may apply per subsidiary.
What you can do:
- Define a Subsidiary dimension in Cube as your multicurrency dimension
- Assign local currencies to each dimension member (e.g., EUR for France, GBP for UK)
- Inherit or override currencies based on dimension hierarchy
- Ensure accurate currency conversions up and down the hierarchy
- Support multiple exchange rates for the same currency pair
- Import rates directly from NetSuite or upload your own
How Currencies by Subsidiary works
Cube staff will assign the dimension to use for multicurrency management (typically this is the Subsidiary or Entity dimension). This enables currency assignment and conversion for all dimension members in this selection, and you can take the following steps to configure and work with currencies.
Note: When using Currencies by Subsidiary, each Subsidiary much have a unique Mapping in Cube. One-to-many mappings aren't available with Currencies by Subsidiary.
1. Assign local currencies to dimension members
Each member of your multicurrency dimension can be assigned a local currency.
By default, members inherit the currency of their parent, but you can override this where needed.
Example
If your parent entity reports in USD, and its two child entities operate in EUR and GBP, Cube will store values in their respective local currencies and convert them during rollups.
| Subsidiary Dimension | Local Currency |
| Example Global Co | USD |
| Example EMEA Co | EUR |
| Example UK Co | GBP |
| Example France Co | EUR |
| Example Americas Co | USD |
| Example North Americas | USD |
| Example USA Co | USD |
| Example Canada Co | CAD |
| Example Acquisition USA Co | USD-Acquisition |
| Example South Americas | USD |
| Example Brazil Co | BRL |
| Example Argentina Co | ARS |
2. See accurate currency conversions
Cube automatically converts values up and down the hierarchy based on the local currencies you've defined. This applies when you fetch and drilldown on data anywhere in Cube
This supports more accurate consolidated reporting, whether you’re budgeting by entity or analyzing global performance.
3. Use custom currency codes for Entity-specific rates
Some ERPs (like NetSuite) allow for different exchange rates for the same currency pair across entities. Cube supports this by letting you define custom currency codes and assign them per dimension member.
For example, one entity might use a different USD to CAD rate than another. Define a custom USD-CAD_A rate and assign it to the appropriate entity.
4. Load exchange rates
- NetSuite Integrations: Rates are automatically imported during data syncs or refreshed on demand.
- Other integrations: Upload exchange rates directly via the CSV uploader in Cube.