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

Flat File Options on Data Extract from TRCS

Received Response
edited May 28, 2019 3:49AM in Tax Reporting 3 comments


When extracting data from TRCS into a flat file are there better options for extracting Entity and Currency dimensions?


I'm creating a flat file extract from TRCS to then be loaded to HFM. The file is created successfully, however, there remains 2 questions:

1. Entity - On extract, the Entity is in the format [Parent Name].[Entity Name]. I really only want the Entity member name. Last time I set this up, only the Member Name was included in the extract.

Is there a setting or means of only extracting the member name? For example 3030 instead of [EMEA].[3030].

My preference is not to manage this with mapping on load to HFM that would have to be maintained going forward.

Howdy, Stranger!

Log In

To view full details, sign in.


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