cannot create a fast refresh materialized view from a complex query

[balajiyes]

Thnx Slimdave.
Then how do I handle this...
I need all the records from day 1 in my dim table till last day of the current month.

eg, first day in my dim table 01-01-2000 and last day of the curent month 30-09-2003.