Skip to main content
E
e_poveda
December 4, 2025
Solved

Transformation Rule - Split - Complex Expression

  • December 4, 2025
  • 1 reply
  • 0 views

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.

Best answer by e_poveda

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.

1 reply

P
PKiernan
December 4, 2025

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.

E
e_povedaAuthorAnswer
December 4, 2025

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.

D
DanielWillis
Employee
December 4, 2025

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.

Terms & ConditionsAccessibility statement