FDMEE not applying LIKE data load mappings
edited Sep 8, 2020 5:03AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 2 commentsAnswered
Hi everyone,
We are loading a txt file into a BSO cube. With one of the dimensions we are experiencing a weird behaviour. The source has some NULL values for one of the dimensions, so we are using a "LIKE" mapping with a SQL script:
This is what the SQL code looks like:
CASE
WHEN UD11 is NULL THEN 'MISC_WINES'
WHEN UD11 = 'NA_MARCA_HFM' THEN 'MISC_WINES'
ELSE UD11
END
So, if FDMEE encounters a NULL, it should be mapped to MISC_WINES; if it encounters 'NA_MARCA_HFM', it should also be mapped to MISC_WINES; else, just match the source and the target.
0