System Parameters File
The dimension file for RA_SRC_CURR_PARAM_G.dat
is not used as part of your history load process directly,
but instead provides an important piece of information to the platform for operational activities. This file must contain
the current business date associated with the files in the ZIP package. The file should be included with the nightly ZIP upload
that contains your foundation data, such as RI_RMS_DATA.zip
or RAP_DATA.zip
.
The file has only two generic columns, PARAM_NAME
and PARAM_VALUE
. When data is sourced
from RMFCS, it will be automatically generated and sent to RI in the nightly batch. If your data does not come from RMFCS,
then you need to include the file manually. Currently, only two rows will be used, but future releases may look for additional
parameters in the file.
The file should contain the following rows:
VDATE|20220101
PRIME_CURRENCY_CODE|USD
The parameter value with VDATE
is the current business date that all your other files were generated for
in YYYYMMDD format. The date should match the values on your fact data, such as the DAY_DT
columns in sales,
inventory, and so on. This format is not configurable and should be provided as shown. The parameter value with PRIME_CURRENCY_CODE
is used by the system to set default currencies on fact files when you do not provide them yourself or if there are null
currency codes on a row.