I am using AS2005 and OWC to create pivot tables and embed them in a VB ASP.NET 3.0 web page.  The user want's us to create a seperate pivot table for each fiscal year and allow the end user to drag fields in and allow them to filter those fields but not be able to change the fiscal year.

My problem is that we are trying to do this with only one cube that has the data for every fiscal year.  In order to set the fiscal year we have to add the fiscal year field into the pivot table and set it's value.  However, the user is then able to manually change the fiscal year. 

I cannot restrict their access to the fiscal year using roles because then they would see all data for all fiscal years.  If I try to connect to a perspectives without the fiscal year then I can't set it's value.  I've tried to set the allowfiltering property to false for the field but that doesn't seem to be possible as it only works for the entire pivot table.

Ideally I would like to be able to connect to a partition like you can with a perspective but that doesn't seem possible.  Our only other option that I can think of is actually creating a separate cube for each fiscal year which I am not crazy about.

Am I able to do this with one of the solutions I've already tried?  If not, is there another way to accomplish this task without having to create a new cube every fiscal year?

Any help or suggestions is greatly appreciated.
Thanks for your time
-Chris