Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos


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.


Accepted Solutions (0)

Answers (4)

Answers (4)

Active Contributor
0 Kudos

hi Anurava,

checked Eugene's weblog ?



hope this helps.

Former Member
0 Kudos

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.



Former Member
0 Kudos

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
0 Kudos

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