Flat File Options on Data Extract from TRCS
Summary
When extracting data from TRCS into a flat file are there better options for extracting Entity and Currency dimensions?Content
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.
Tagged:
1