Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Attempting to create a lookup table, getting syntax error

31
Views
2
Comments

I am attempting to use SQL to create a report that determines whether a procurement was completed late or not depending on a number of factors.


Due to the many conditions that need to be defined, I am attempting to use a lookup table to make it more efficient. However, I am encountering a number of errors when i try to make the report.


I would appreciate if you could confirm if this method is possible, and if so could look over my the code and suggest any fixes,


Thank you

Tagged:
1
1 votes

Submitted · Last Updated

Comments