The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Transformation Rule - Split - Complex Expression
I need to get, from a Custom Dimension, the characters starting after "D." or "T." when it's possible. Normally it comes as D. or T. at the beginning, followed by XYZ. What I want to get, as a direct mapping, is XYZ (these are the members created in the Custom Dimension in OneStream).
What type of mapping can I use for this? I don’t want to trim the source member in the Data Source because I need the full original source member to appear in Stage.
Thanks for your answer.
I had been testing different approaches as you suggested, but in the end, for it to work, it has to be done through a Complex Expression.
3 Replies
PKiernanOneStream Employee
Have you tried a Mask rule where the Rule Expression is D. and the target value is *, Or D.??? to ??? . This is assuming the source star equals to target star, or the length of the question marks and source and target values are the same.
Thanks for your answer.
I had been testing different approaches as you suggested, but in the end, for it to work, it has to be done through a Complex Expression.
I know you said you wanted to have the full member in stage. Another option is to map the trimmed member in the data source to a different column that isn't used so you have both.
