2 Replies Latest reply on Mar 1, 2013 10:39 AM by user2041006

    OBIEE 11g - Essbase Performance Problem

      Hi All,

      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 ?