on 09-28-2011 10:58 PM
Hi gurus,
I have first name and last name but user wants to see both values concatenated with a space in between.
I am trying to do it at DSO to Cube transformation level.
I have joined first name and last name to a single field in the cube and using formula concatenate but unable to put a space between.
Your help will be appreciated.
Thanks.
You can add one infoobject as name in target (cube). In transformation you can map first name and last name coming from DSO to Name infoobject in cube. There you can write a formula and use -
/BIC/fname & ' ' & /BIC/lname
OR
CONCATENATE(/BIC/fname, ,/BIC/lname)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Never mind, got it fixed using a routine in transformation:
Concatenate SOURCE_FIELDS-/BIC/Z_NAME1 SOURCE_FIELDS-/BIC/Z_NAME2
into RESULT separated by space.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.