I'm trying to utilize the user level logging in the RPD where the query's physical SQL is wrote to the nquery.log - I think the file is called $OBIEE_HOME /user_projects/domains/<domain>/servers/obis1/logs/obis1-query.log now in 12c, however I'm unable to get any queries logged. I've went through setting the user logging to level 2 via the Admin Tool but its not logging anything. Is obis1-query.log the correct file to look for this logging or is there another configuration step that's required in 12c?
In the Analysis add the following to the prefix box on the Advance tab
Set Variable LOGLEVEL=2;
Not sure why the RPD server setting doesn't work.