Dear Friends,
We are using BI7.00. For one of our reports, we have in the data source a field which has concatenated value of plant,module etc., In the transformation, i have seperate infoobject for plant and module, now i want system to remove the plant value alone from the concatenated value and pass it to the infoobject plant similarly for module also. The details are as shown below.
Field in the datasource :- User which has for example values like this Z2100QMC01 in which the 2nd to 5th character is plant i.e., 2100 and the 6th and 7th character are modules.
I tried to use the LEFT function in formula in the transformation but this did not yield result. Can experts provide the syntax for achieving this requirement.
I want to achieve this only by using formula in transformation and not to use any abap coding.
Regards,
M.M