Forum Stats

  • 3,853,984 Users
  • 2,264,302 Discussions
  • 7,905,523 Comments

Discussions

Oracle Error in workbook

MarcLaf
MarcLaf Member Posts: 182 Bronze Badge
edited Jun 15, 2017 3:08AM in Discoverer

Hi,

I have a Workbook with a Condition and a Calculation criteria:

Calculation: 

calculation.JPG

Condition:

Conditions.JPG

Running Oracle BI Discoverer 11g...

When I execute the workbook, I get an Oracle Error:

error.JPG

If I take out the Condition from the workbook, Everything works fine, No error!!!

Can someone shed a bit of light on this?

Thanks in advance,

Marc L

Answers

  • Brajesh Shukla
    Brajesh Shukla Member Posts: 374
    edited Jun 15, 2017 3:08AM

    You can use table with outer join only with one table. This is syntax issue while joining the tables, please correct it, then should work.

    You can get the SQL from View SQL Inspector or DIscoverer Administrator. to find out which table exactly causing the issue

This discussion has been closed.