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!

Anybody using AGO function and query REWRITE successfuly?

533719Jul 17 2008 — edited Jul 21 2008

Hello!

I have problem with queryies using AGO function that don't REWRITE.

I have a sales fact table with TIME dimension at day granularity.
Then I created MV at month granularity.

Time dimension: day-month-year

For normal queryies OBIEE functions OK and rewrites query to use MV.

I created AGO expression AGO(sales_neto,time_dimension_year,1)

And with this AGO expression I can't force OBIEE to use MV. Am'I doing something wrong or is this a ''functionality''?

I use OBIEE 10.1.3.3.1 strictly Oracle 10g on linux.

I also imported the MV and ''MONTH dimension'' into OBIEE but no improvment with AGO function using MV (although oracle REWRITE functions OK for ''normal'' queryies even without importing).

Thanks

Gorazd

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2008

Added on Jul 17 2008

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

5 comments

1,802 views