Failed to create a report and try to view the SQL

Asked By Jeffrey B Smith 0 points N/A Posted on - 08/10/2013

Hello,

I get the problem when I create a report and try to view the SQL or run the report because I get the incompatible combination of objects when I try to access an object from table that I added to a universe.

Thanks for any suggestion to resolve this annoying error message.

Warning

Refresh failed

Incompatible combination of tables.

 

• Status: Open
• Question Views: 666
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Newman Gust 0 points N/A #177250

Failed to create a report and try to view the SQL

Such an error due to “incompatible combination of objects” comes up while running reports if there are unresolved loops in the universe. Basically, the error comes up to ensure that no misleading/incorrect results come up.

 Reconsider and redesign your base sql/joins to check for any unresolved loops.  Correcting the sql would probably help resolve the issue.

About Newman Gust

Questions
0

Answers
13

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/29/2013
• Question Category: Database