Tuesday, February 22, 2022

Oracle EPM Cloud - Data Management : How to use special characters, Prefix/Suffix, replace characters using Multi-Dimensional mapping

Source

Map only specific entities (IND, EUR, JAP)

Cost center* dimension begins with (03****) 

Target

Map to target Cost center dimension - 

  1. Add a prefix CC 
  2. Members begins with 03**** in source should map to 04**** in target

Example

Source 
Entity : IND, EUR, JAP 
Cost Center : 03MCHJ, 03JIUY, 03KIJY

Target
Cost Center : CC04MCHJ, CC04JIUY, CC04KIJY


SOLUTION

In the Target value define     #FORMAT("CC04##????")




No comments:

Post a Comment

Other posts

How is the data size calculated for a EPM Cloud service instance?

The total size of data used by your EPM Cloud service instance is the sum of the following: Application data stored in Essbase Artifact...