Oracle Analytics and AI

user4109719

What is the SQL syntax for a logical column in the RPD?  I'm trying to enter this:

SELECT "Organization Dimension"."Organization" 

FROM "Travel" where "Organization Dimension"."Organization" =  VALUEOF(NQ_SESSION.SESS_USER_LDAP_ORG) 

It says there's a syntax error "near <">".  It gives 2 error numbers:  27002 and 26012.

Gianni Ceresa

A logical column formula isn't a SELECT LSQL.

A logical column is attached to a logical table, a logical table has one or many logical table sources. The logical table source define the mapping between a logical column and a physical table or between the local column and another logical column.

There isn't any SELECT ... syntax as it is what the LTS does.