Unable to load Entity, Currency, Drill Through

Summary

Issues with FCCS (source) to ARCS (Target) Integration

Content

The client wanted FCCS as a source for ARCS. To make this possible, as a workaround, we have registered FCCS as target to make the epm cloud to epm cloud integration working. However, we are facing the following issues in Data Management :

1. 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 Columns :   Entity/ Any Dimension (Expression "-") / Account
    Target for all these source columns : Profile (Combination of Entity & Account with "-" in between)