I have 2 InfoObjects in my InfoCube "ID" & "Type". I would like to concatenate these 2 InfoObjects in the Query and show them as 1 field. While at the sametime I would not like to create a new InfoObject to store the concatenated value.
I have ....
ID , Type
100 , User
I would like to show it as 1 field in Query display....
User : 1000
Is this possible with BEx Query Designer and how ?