There is no direct equivalent in ObjectScript to the ternary operator. You can use $SELECT or $CASE

Yes, that would work. You can test that in RelatedCubes/Patients and RelatedCubes/Patients. The downside of this approach is having to use cube relationships, which are more complex to maintain and in general have slower queries.

Hi Evgeny,

I think I'd better leave the answer to somebody with more experience in this field.