5 Replies Latest reply: May 21, 2012 2:49 AM by 933162 RSS

    Question with DATE repository variables in OBIEE 11.1.1.6 filters

    933162
      Hi there,

      this is my first post in this forum, even if I have been using OBIEE for nearly 2 years now.

      We are using OBIEE 11.1.1.6 now, and we have encountered an issue I don't know how to resolve.

      Our repository does have a repository variable var_dia_ant that is working fine.

      But when I try to create a BETWEEN filter for a date field, the filter window doesn't allow me to use a repository variable instead of an actual value. This used to worked fine in OBIEE 10.

      Please, see the pics below:

      BETWEEN filter in OBIEE 10
      http://tinyurl.com/bvw8c8x

      BETWEEN filter in OBIEE 11.1.1.6
      http://tinyurl.com/cqdz5n5

      Could someone please explain me how can I create a between filter for dates using variable repository.