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

Concatenating source dimensions for Profile

Accepted answer
edited Oct 19, 2018 9:33AM in Account Reconciliation 7 comments


Data Management is unable to concatenate Entity and Account



A typical import format for ARCS as a target would have the following mapped to the Profile 'dimension':

Source Column Expression Target
Entity   Profile
(any dimension)  - Profile
Account   Profile

However, when I try importing balances, Data Management is unable to concatenate the source dimensions into the Profile dimension. 

For this particular case, the source is FCCS. I have tried various combinations: Removing the hyphen from the import format, keeping the dummy as:

  • some inconsequential dimension like data source
  • Account
  • Entity

In all of the cases, either the Account is not mapped to the profile dimension or the Entity is not mapped to the profile dimension. File based import works without any issues.

Howdy, Stranger!

Log In

To view full details, sign in.


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