Concatenate 2 InfoObjects in the Query Designer for Display

Hello Colleagues,

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....

Value

-

User : 1000

Is this possible with BEx Query Designer and how ?

Kind Regards,

priyadarshi