Data loads in HFM are incorrect due to FDMEE To HFM User Preferences Delimiters For Thousands And Decimals (Doc ID 2921336.1)

Last updated on FEBRUARY 03, 2023

Applies to:

Goal

On : 11.2.8.0.000 version, Product Usage and Application Development

FDMEE to HFM user preferences delimiters for thousands and decimals

FDMEE and HFM 11.2.8 The issue is while loading data with FDMEE into HFM creating confusion because of HFM user's preferences delimiters

Environment 1: FDMEE is configured to always use the American separator (i.e. thousands with "," and decimals with "."),

this means that FDMEE after importing and processing the data from a csv file, generates a .dat file which contains the values using American delimiters before uploading that file into HFM.

Then depending on the user HFM's preferences it will upload those values in FDMEE unknown if its happening correctly.

Environment 2: the user's preferences for HFM are set with delimiters in European format (i.e. thousands with "." and decimals with ",") then HFM interprets these values incorrectly and carry out the load with huge numbers (many ceros at right), however if the HFM user's preferences are set with American delimiters, then HFM interprets the numbers correctly.

This is generating a big confusion and sometime data loads in HFM are incorrect due to this issue.

Question, is there any way to make HFM ignore the user's preferences (delimiters for thousands and decimals) and apply always the same delimiters (American delimiters in this case) no matter who makes the data load via FDMEE? Note we want to maintain the HFM user's preferences delimiters for the rest of use cases but not for importing data from FDMEE into HFM
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.