Skip to Content
0
Former Member
May 18, 2010 at 02:50 PM

drill on number and name

25 Views

I'm trying to set up custom drill path on an cost center name and cost center number using a BEX sourced universe. The name and number are separate fields in the BEX query so they come into the universe as separate objects. In looking at other forum posts I found that you can not create a universe object that is the concatination of the name and number, therefore I can only create a drill path on either the name or the number, not the combination of. The result is if I drill on number the name doesn't change and if I drill on name the number doesn't change.

Has anyone ran into this type of issue before and how did you solve it? My BW admins do not want to create a concatenation of the name and number in the database, but that is all that I can think of. If there is a way to concatenate the name and number into one object within the universe than I'm all ears.

Thanks,

Tim