Skip to Content
0
Former Member
Dec 23, 2016 at 05:47 PM

The query cannot run, because it contains incompatible objects error in universe.

505 Views

The object is created in universe using a case logic (derived with two different dim tables). when I Parse it and performed check integrity the below error is seen.

"The query cannot run, because it contains incompatible objects error".

I have seen below solution in SAP community.

Action:

The universe designer can do the following:

  • Select the options Multiple SQL statements for each context and Multiple SQL statements for each measure. These are on the SQL page of the Universe Parameters dialog box.
  • Create a new context that includes the incompatible objects.

Please let me know whether

  • do I need to create a separate context using the two dim tables only.
  • At the moment I have included the two dims (shared dimensions) in both contexts (as we had two fact tables only).While creating the separate context do I need to remove from other two contexts.

I am bit new to SAP BO. Can anyone please help.