Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 24, 2016 at 04:57 AM

    plz put your query here so suggest you any changes in it

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2017 at 01:43 AM

    A dimension 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".

    Could you help in clearing my confusion.

    At the moment I have created two same objects as we had only two fact tables to eliminate the error and which may not correct solution.

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2017 at 01:43 AM

    A dimension 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".

    Could you help in clearing my confusion.

    At the moment I have created two same objects as we had only two fact tables to eliminate the error and which may not correct solution.

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

    Add comment
    10|10000 characters needed characters exceeded