In one of my recent projects we were using Oracle Analytical functions such as Lead, lag, Model & more, to enable this functions in OBIEE the work around seems to be to modify the NQ Config under the Cube Views section this will enable the analytic SQl .
Hope this helps.
