I would like to apply a second time dimension to a cube that limits the view
to only the past 12 months. I have created a time dimension that only
contains the last 12 months based on the current date and applied it to the
cube. However, there are measures in the cube with dates that fall outside
this range. When processing the cube, it sees these out-of-range dates and
stops with an error that says "The record was skipped because the attribute
key was not found".

How can I apply this dimension to a cube without getting errors? Is there a
better way that I can create this "view" of the cube that only returns 12
months?

Thanks,
Stephen Sanders

You could create a dimension with 2 members Current and Old. Set the fact
values to the correct member and the user can select, but you would set the
default member to Current.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


"Stephen Sanders" wrote: