This discussion is archived
2 Replies Latest reply: Jan 31, 2011 2:58 AM by 834996 RSS

OBIEE 11g time series: regression on ago / todate function ?

834996 Newbie
Currently Being Moderated
Hello,

We are testing the migration to OBIEE 11G.
We are currently in 10.3 version

We have a problem on AGO / TO_DATE OBIEE functions that returns null results on existing reports.
In 10.3 version, these functions work properly with the actual TIME dimension.

Here is how we designed time Dimension:

TOTAL -> Year -> Quarter -> MONTH -> WEEK -> DATE_KEY, FULL_DATE

DATE_KEY is a number and referenced as a foreign key on our fact table.

CREATE TABLE TD_DATE
+(+
DATE_KEY NUMBER (11) NOT NULL,
FULL_DATE DATE
WEEK NUMBER (2),
MONTH NUMBER (2),
QUARTER NUMBER (1)
YEAR NUMBER (4),
TOTAL_DATE VARCHAR2 (11 BYTE)
+)+

Database version: Oracle 11g

All elements of the dimension are chronological key (except full date) in order to optimize performance.

Have you encountered similar problems in inplémentation of AGO / TO_DATE function on version 11g?

Thanks,

Romain

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points