Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Concatenating source dimensions for Profile — 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

Concatenating source dimensions for Profile

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

Summary

Data Management is unable to concatenate Entity and Account

Content

Hi,

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.

Register

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