Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question with DATE repository variables in OBIEE 11.1.1.6 filters

Albert_GiraltApr 27 2012 — edited May 21 2012

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2012

Added on Apr 27 2012

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

663 views