i have a date dimension table; and I would like to be able to use one table
to join to MONTH + YEAR; and use the same table to join to a DATE field.

I just don't want to maintain 2 different dimension tables. And I don't
want to base the MONTH dimension on a view.

Right now, it is cartesianing my data.

I have one table named DIM_DATE
DATE, DAY, MONTH, YEAR; etc

I want to use this same dimension table in order to join to Fact tables on
the month granularity and the day granularity.

I can't figure out how to do this-- If i could just put a dimension filter
on the dimension in the cube editor, that would take care of the problem.

I could make a 2nd DATE.MONTH dimension; and have a filter where DAY = 1

I just was planning on using this dimension to join between 2 cubes in a
virtual cube; and i can't see how to do this.

I did figure this out-- All I needed to do was put a filter on the cube for
the dimension table.

I was thinking that we could only filter based on the fact table there, but
that worked like a charm (adding a clause where DIM_DATE.DAY = 1)

-aaron


"aaron kempf" <aaron_kempf (AT) hotmail (DOT) com> wrote