Incompatible Combination of Objects 1

[Smithsc]

Hi,
I am trying to build a simple universe using just 2 tables. (a company details table and a users table). I picked 2 fields from the company table and created a custom object field from the users table. The tables are joined correctly but when I try to test the universe using a webi query I keep getting the error message Incompatible Combination of Objects (QP0004)

The custom field reads:
RTRIM(Company_User_RM.User_FirstName) + ' ' + RTRIM(Company_User_RM.User_LastName)

If I create a query using just the custom fields it works perfectly.

Where am I going wrong?

I am using Universe Designer XI querying an SQL database.

Many thanks for any help given..

 

[blom0344]

Did you apply a context for each seperate table? (and use objects from both tables in your report?)

Ties Blom