Why some fisical tables&columns aren't available in some views for Freehand SQL calculated fields?
We have two views in our data model which points to the same physical table (YF_COURSE) and, among others, with the same physical column (COURSE_ID).
If we create a report from each view with the logical column ("Courses"."Course id"), both works. If we display the SQL related to both reports, both SQLs display "YF_COURSE.COURSE_ID" as the physical column.
The problem appears when we create a Freehand SQL calculated field with this SQL code:
substr(YF_COURSE.COURSE_ID,7,1) to get the 8th digit.
We are able to create the calculated field and make it work in view A but we are even able to create it in view B. The error message says:
Why does it work in view A and doesn't work in view B?
Thank you very much for your help.