Can I combine the out put of TWO FIELDs into One fields in BW query

[Former Member]

Hi,

For example, I have two fields ‘FIRST name’ and ‘last Name’ in the info provider and in theBW query these two are displayed in two separate field with independent drill down capability, Can I combine those and show as a single field with a single drill down capability.

Thanks

[edwin_harpino]

hi Anurava,

checked Eugene's weblog ?

/people/sap.user72/blog/2006/06/05/long-texts-in-sap-bw-displaying-in-bex-analyzer-introduction-to-excel-workbooks-formatting-part-i

/people/sap.user72/blog/2006/06/05/long-texts-in-sap-bw-displaying-in-bex-analyzer-introduction-to-excel-workbooks-formatting-part-ii

hope this helps.

[Former Member]

Hi Arunava,

Combination of two fields can be done at Excel level where we will not get the drill down. We can rather use use an object which is compunded for the two names and then add them in the cube. we can achieve the functionality of drill down on the report level.

Hope this will help you in resolve the issue.

Regards,

Phani.

[Former Member]

Yeas Arunava,

can do this if you are using the EXcell as a fronth end.

u have to use excell functionality OR write micro to get the clubbing of names into one column.

[Former Member]

Hi Arunava, You can combine these two fields in the infoprovider but in query i don't think it is possible...

Thanks,

Vachan