Is it possible to concatenate two Source Columns to load into a dimension when the source is ERP-GL?
We are using Oracle ERP Financials and have two segments, Program and Activity. In Planning, we are going to combine the two to make up a dimension (Program_Activity). I saw that it is possible in Data Management using Import Format to concatenate two source columns when using a file as the source, but can I do it when my source is the GL cube? And if so, how?
Any guidance would be greatly appreciated. Cheers!
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):