Skip to Content
0
Former Member
Nov 05, 2011 at 02:17 AM

Adding Merged Dimensions In Reports Receiving Incompatible Object

221 Views

I've created a report using data from 3 separate queries. My first query includes a Shipper and Ship To field but the universe that stores these dimenions does not include a shipper or ship to country so to include it I created two additional queries from another universe that stores reference data pertaining to organizations including the "Country Code". I merged the "Shipper" dimension from query 1 with the "Organization Identifier" dimension in query 2 and the "Ship To" dimension from query 1 with the "Organization Identifier" in query 3.

When I tried adding the merged Shipper and Ship To dimensions to the report along with the "country code" from query 2 that would give me the country of the Shipper organiztion and the "country code" from query 3 that should give me the Ship To organization country, I get a "cannot drop here. incompatible object" message.

What do I need to do so that I can have both the Shipper and Ship To that are contained in one universe and corresponding country codes for the shipper and ship to organizations stored in another universe in my report. Below are the dimensions:

Shipments Universe--Shipper Organization Identifier

Shipments Universe--Ship To Organization Identifier

Organization Reference Universe--Organization Identifier

Organization Reference Universe--Organization Country Code