OBIEE 12c RPD how to put sql code in session variable as default

Question

I have a session variable in the RPD of OBIEE 12c and I wanted to put a small sql code in it as default initializer. It's something that selects only one row but this gives a syntax error (the sql is correct, I've tested it). Is this possible? Or are there any other ways to make the default dynamic?

There is also one other thing: I only have the category constants in my tab 'category' of the expression builder.

Answer 1

You can't use SQL to set your default initializer, that's why you only see Constants as an option. It's meant to be a constant value. The initialization block is used to set your session variable to a dynamic value.

https://docs.oracle.com/cd/E28280_01/bi.1111/e10540/variables.htm#BIEMG3104

Answer 2

You want the content of the variable to be a SQL statement as a string?

Like VALUEOF(NQ_SESSION.MYVAR) = 'select ''This is jist some text'' from dual;"?

Cause that's what you then get. Text. Uninterpreted. Like typing a sentence, not code.