cancel
Showing results for 
Search instead for 
Did you mean: 

Combining dimension objects

former_member672670
Participant
0 Kudos

Hi Guys,

I have 2 dimensions objects - "Manager Name" & "Director Name" belonging to the same class in my Universe. Now, I want to combine these 2 objects into one so that I have a single list.

1) Could anyone please help me achieve this in Webi 4.1?

2) Also, can I combine them in the Universe (UDT 4.1) itself?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

HI Jeewan,

2) Also, can I combine them in the Universe (UDT 4.1) itself?

          Please refer this link

Former Member
0 Kudos
arijit_das
Active Contributor
0 Kudos

1. You need to create a dimension variable in WebI as =[Manager Name]+" "+[Director Name]

2. There should be concatenation function available based on the database you are having. In UDT, you can create a new dimension object to concatenate Manager Name and Director Name. Note that if you are using OLAP universe, this operation will not be possible.

former_member672670
Participant
0 Kudos

Hi,

I am not trying to concatenate the values. I am trying to create a single list as shown below.

e.g.

Director Name          Manager Name

A                                   X

B                                   Y                                       

C                                   Z

Now, I want to create a dimension or a variable that has the combined list i.e.

A

B

C

X

Y

Z

Is this possible?