Merge objects in a cell

[pippotim]

Hi, I have two Data providers (with the same objects) on two different universes.
If it is possible, how can I merge two identical objects
in one field (like a Union in the query) on the blocktable of the report?
example:
I have to view CityDes(Query 1) and CityDes(Query 2) merged in a cell
in the same blocktable ordered alphabetically.

 

[blom0344]

If the object you are referring to is the object belonging to the dimension you are linking the DP's over, BO woll automatically perform a full outer join (at least, I think you mean that by merging)

Otherwise:

= If IsNull(CityDes(Query 1)) then CityDes(Query 2) Else
CityDes(Query 1) as a new variable for the column...

T. Blom
Information analyst
tbl@shimano-eu.com

 

[pippotim]

It is just what I want. Thank you.