We're trying to create predefined date filters in our FM model for use by the users when they create Query Studio reports against the business view. The problem we're running into is the date filters must be based on our fiscal calendar. For example, this year our fiscal calendar runs from 2/1/09 thru 1/30/10.
One of the filters should limit data by the last 5 years + the current year. I'm retrieving the current date via a DB2 system table and joining it to our calendar table, so that all the fiscal info is available.
I created a parameter map and based it on a query subject. Everything worked perfectly the day it was created. However, using the parameter maps in the filters, I see that they've hard-coded the current date: [Systems View].[TN1ODCAL (Ship Date)].[CCYY_FISC_NUM] >= ( #$[Current Date Fiscal Year (CCYY)]{'Aug 17, 2009'}# - 5 )
Therefore, everything worked perfectly the day it was created on 8/17/09. However, it does not work now. I need the filter to not have a hard-coded date. I've attached screenshot from what I did. Anyone have any thoughts? I hope I explained this clearly. Thanks!!!
Sadly, I cannot upload an attachment. It tells me the directory is not writable...