1. I need to have a named set/calculation appear in the pivot table fields
list (Office 2003) so that I can filter a time dimension down to the last 15
periods. In order to do this, I was thinking I need to setup a dimension
hierarchy with the WkYr attribute in it and somehow filter for the last 15
months. This is exposed to the pivot table and then I can drag it onto a
table or chart and see only the last 15 months...How do I enable this? I
can't figure out how to filter this attribute.....

2. To filter values in the AS2005 browser to get the last 15 periods, I have
used a named set defined as :

[Last 15 periods] = LastPeriods(15,[WkYr].[Wk-26-2006]).

I can use this in the AS2005 browser to filter to the last 15 periods. How
do I make this relative to the last period with data instead of to a specific
week [Wk-26-2006]? My attempt was:

LastPeriods(15,NONEMPTY([WkYr].Members,
[Measures].[A_WarehouseLbrCostPerUnit]))

The expression could not resolve the [Measures].[A_WarehouseLbrCostPerUnit]
reference, although it is in the cube

I appreciate any help you can provide.