Hi Ashok,

In AS 2005, dimensions are processed separately from the measure group
partitions. Even in AS 2000, if you optimize the schema for shared
dimensions, a dimension table may not get joined to the fact table
during partition processing.

If you need to filter fact table rows based on the date dimension table
in the DSV, you can right-click and replace the fact table with a named
query. The named query can return the same fields as the fac table, but
include an inner join to the date dimension table.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***