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.
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.