2 Replies Latest reply: Mar 1, 2013 4:39 AM by user2041006 RSS

    OBIEE 11g - Essbase Performance Problem

    user2041006
      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 ?

      Thanks
      Youssef