I'm have one query in OBIEE with Hardcoded Filter (exemple Year = '2012'), the query send it to Essbase contains this Filter.
But If I use Session Variable into the Filter (exemple Year = NQ_SESSION.VALUEOF(CURRENT_YEAR)), the query send it to Essbase doesn't contain this Filter.
So, the query in Essbase take a long time, and then OBIEE takes time to Filter Data in OBIEE Server.
My question : How can OBIEE substitue the Session Variable Before sending query to Essbase ?
Maybe you could create a dashboard prompt with your filter and with a default value NQ_SESSION.VALUEOF(CURRENT_YEAR)).
After in your report you add a filter "as prompted" on your field.
If you want you can hide the dashboard prompt to not show it.
It is not the best solution but it could be a workaround in your case - I don't test it.
Hope it helps,