Skip to Main Content
Forums

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.

Comments

Srix
did u try changing the filter to SQL ? and specify your variables ..
1 person found this helpful
Albert_Giralt
Thanks for your input, it was very helpful.

I did try to use a SQL filter and it worked fine.

"Tiempo"."Dia (Cod)" between valueof(Var_Dia_Ini) and valueof(Var_Dia_Ant)

Anyway, this is not something I can ask my users to do on a regular basis. Previous versions of OBIEE allowed them to use report variables when filtering dates, same they do for filtering other types of fields. The fact that it does not work for dates makes think this is a new bug introduced in 11.1.1.6 (or maybe even 11.1.1.5).
Srix
Seems like a bug for me .. You should open an SR

~Srix
Albert_Giralt
Yes, that I did.

I will let you know when they give me some solid info on this issue.
Albert_Giralt
As we have already guessed, it is a known bug.

Bug 13886662: OBI 11.1.1.6 DATE FILTER: THE VALUE ENTERED MUST BE A DATE AND TIME IN THE FORM

Weird it didn't pop up on the searches I did.

Well, I can only hope it will gte fixed ASAP.

I am marking this question as answered, since there is really little that can be done until it's fixed.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 18 2012
Added on Apr 27 2012
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
5 comments
658 views