Skip to Content
0

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

Dec 23, 2016 at 05:47 PM

189

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 09, 2017 at 01:43 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 09, 2017 at 01:43 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded