Concat function is unavailable when source application is a BIP report and what is the alternative?
I am trying to build an integration in EPM to build metadata hierarchy for various dimensions wherein source is based on a BIP report built in ERP (General Ledger). The report looks like as shown below:
Now, alias structure we have in EPM is for example considering the second row : 9710000 - Services Français/Archives numérisées/RI
We have been able to achieve this using concat function available in source expression in our other file-based integration but for BIP, the function is missing (see below screenshot)
How can I solve this? Do we have to create SR or is there an alternate method to handle this in EPM?
Tagged:
1