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?
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).