Combining dimension objects

[former_member672670]

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?

[Former Member]

HI Jeewan,

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

          Please refer this link

[Former Member]

Hi,

please readhttp://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp4_ia_desktop_en.pdf

regards

[arijit_das]

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]

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?