Oracle Retail Knowledge Base

Initial setup - W_GLOBAL_CURR_G

1 min read

Context

W_GLOBAL_CURR_G defines the three global reporting currencies that AIF_DATA converts transaction amounts into. Every fact that carries an amount is stored in the transaction currency and in these three global currencies, so the values must be set before the first load. Changing them later means reloading the affected facts.

Must match the currency in C_ODI_PARAM

The CURRENCY_CODE global parameter in Initial setup - C_ODI_PARAM is set to EUR, and the three columns below are set to EUR as well. If one implementation changes, so must the other.

Configuration

Connect through APEX, or navigate AI FOUNDATION CLOUD SERVICE > TOP LEFT MENU > Tasks > Control and Tactical Center > Manage Configurations > select the table W_GLOBAL_CURR_G.

All three global currencies are set to the same value, so every global amount column reports in euro:

-- GLOBAL REPORTING CURRENCIES
update w_global_curr_g
set
	GLOBAL1_CURR_CODE = 'EUR',
	GLOBAL2_CURR_CODE = 'EUR',
	GLOBAL3_CURR_CODE = 'EUR'
where
	DATASOURCE_NUM_ID = 1;

Reference

Graph View

Backlinks