How to load HFM data with Year and Period in multiple rows to FCC ? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to load HFM data with Year and Period in multiple rows to FCC ?

edited Jul 31, 2025 1:11PM in EPM Platform and Freeform 3 comments

Summary:

I’m trying to figure out how I can load data from HFM to FCC.

Content (please ensure you mask any confidential information):

The HFM extract comes in this format:

!DATA

Actual; 2025; Jan; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -140

Actual; 2025; Feb; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -447

Actual; 2025; Mar; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -1123

What would be the best approach to have Data Management to look at the second and third column (e.g. 2025: Jan) and transform this into FCC format (FY25; Jan) for multiple columns with Period varying through rows?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!