In Answers, I can create this formula to return the user's time zone: '@{session.timeZone}'
Is there a way to create that formula, or something similar, in the Business Model layer of the RPD, so that it can become a simple selectable column in the subject area, and thereby avoid having to build the custom formula in an analysis? I've tried every type of syntax I can think of to reference a system session variable within a logical column in the RPD, none of which work.
I am able to create a logical formula such as VALUEOF(NQ_SESSION.LOGLEVEL), which references the LOGLEVEL system session variable, and that one works, but only because I am setting LOGLEVEL in an initialization block, which makes it appear in the list of selectable session variables on the Expression Builder. The timeZone is set in the user interface under My Account, and therefore doesn't show up in that list. The formula VALUEOF(NQ_SESSION.TIMEZONE) returns 'The session variable NQ_SESSION.TIMEZONE has no value definition.'
Thanks!