using ACTIVE_DATE in CUBE ( Bug 16601554 MISSING CODE CLAUSE USING ATTRIBUTE ACTIVE_DATE IN A CUBE F

Hi,

I'm using OWB 11.2.0.3.

I want to fill a cube with some SCD Type 2 Dimensions. I want to use ACTIVE_DATE in my cube to match the best row in my Dimension.

In official document, it is written that the ACTIVE_DATE value is used like this:

...

WHERE

(...

   (<dim_name>.DIMKEY = <lookup_for_dimension_dimkey> AND

           (<level>_EFFECTIVE_DATE <= ACTIVE_DATE AND

<level>_EXPIRATION_DATE >= ACTIVE_DATE) OR

           (<level>_EFFECTIVE_DATE <= ACTIVE_DATE AND

                    <level>_EXPIRATION_DATE IS NULL))

...)

But the generated scripts is like this:

(EXPIRATION_DATE IS NULL)

OR

(EXPIRATION_DATE IS NOT NULL AND ACTIVE_DATE BETWEEN EFFECTIVE_DATE AND EXPIRATION_DATE)