If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filters and Parameter Maps in Framework Mgr.

Started by mjcotter, 02 Sep 2009 09:50:58 AM

Previous topic - Next topic

mjcotter

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!!!

mjcotter

Sadly, I cannot upload an attachment.  It tells me the directory is not writable...