TM1 Forum

Hi Guyzz,

Need your help.
I have a dimension (D) with data in the form of
1. abc_defg ,
2. pqrs_xyz ,
3. mnr_tylr . ( elements length not same)
I have to load this data in 2 dimensions say D1 and D2, in such a way -
D1 will have elements abc, pqrs, mnr (ie part of string which was present before "_" )
D2 will have the elements defg, xyz, tylr (ie part of string which was present after "_" ).

How to achieve this ?

Fairly straightforward I'd say.

Set your data source as the ALL subset of the source dimension.
In the Metadata tab, use SCAN to find the position of the '_' and SUBST to get the two components
Add the elements to each of the two destination dimensions.