FCCS Data Exchange - RATES Integration Issue - DATAVIEW
Summary:
We have configured a RATES cube integration, which is supposed to import FX rates from a CSV file into the FCCS RATES cube.
We are unable to correctly map the View to ‘FCCS_Periodic’. After analyzing the log file in more detail, we came across the following entry:
2025-10-20 12:34:32,283 DEBUG [AIF]: SELECT ENTITY,UD1,CASE DATAVIEW WHEN 'YTD' THEN 'FCCS_YTD_Input' WHEN 'Periodic' THEN 'FCCS_Periodic' ELSE DATAVIEW END,SCENARIO,YEAR,PERIOD,
CASE WHEN (DATAVALUE = 'FCCS_Entity Input') THEN 'Entity Currency' ELSE CURRENCY END,ACCOUNT,AMOUNT
FROM AIF_HS_BALANCES
WHERE LOADID = 462
ORDER BY ENTITY,UD1,
CASE DATAVIEW WHEN 'YTD' THEN 'FCCS_YTD_Input' WHEN 'Periodic' THEN 'FCCS_Periodic' ELSE DATAVIEW END,SCENARIO,YEAR,PERIOD,
1