Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Oracle Error in workbook

MarcLaf
Member Posts: 179 Bronze Badge
Hi,
I have a Workbook with a Condition and a Calculation criteria:
Calculation:
Condition:
Running Oracle BI Discoverer 11g...
When I execute the workbook, I get an Oracle Error:
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
-
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.