Concatenate 2 InfoObjects in the Query Designer for Display

[former_member338469]

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

[Former Member · Accepted solution]

Hi,

I think you can do that by writing an exit.

Another option is by compounding these 2 objects.

Other easy option is doing it in a workbook.

You can try these options without using a new

infoobject.

I hope this will help you.

Message was edited by: AVR - IGA

[Former Member]

Hello Priya,

Could you please let me know on how did you solve this concatenation ?

Thanks,

Venkat.

[Former Member]

Hi Priya,

Please would you let me know, how was this problem of concatenation solved.

I need it urgentlyy.....

Thanks in Advance..............

[Former Member]

Hi Hitesh,

Could you please let me know on how did you solve this concatenation ?

Thanks,

Venkat.

[Former Member]

Hi,

If you are comfortable with ABAP you should consider virtual Characteristics. In that way you don't need to change your data model, as the compound will be done on the fly. Take a look at:

for more reference.

Other possibility is to use VBA to make the compound in the Bex Analyzer.

Regards,

Xibi