I have a report with 2 data providers, each using a universe with a separate connection. Each universe has a variable department of the same type. Is it possible to have a variable in the report which is the intersection of these two objects?
bension (BOB member since 2005-09-01)
If you’re talking about linking two cubes in a report, the answer is yes, as long as the dimensions perfectly conform. e.g. no trailing spaces in one of the queries, no leading zeros in one query only, dates of the same type (not one as a date and the other as a character object).
anorak 
(BOB member since 2002-09-13)
But if you link the two cubes, doesn’t it give you the union of the two objects? I want the intersection.
bension (BOB member since 2005-09-01)
Thanks, that did the trick. I would never have figured that out without some help.
bension (BOB member since 2005-09-01)
(BOB member since 2002-09-19)