Create a pre defined filter for ad hoc reporting

[Sep2013]

Hi gurus,

Is it possible to create a filter in cognos, that can be used for ad hoc reporting .
Ex. current month to date.
If yes, will be it created in Framewok manager?

[blom0344]

Yes and no..  For a specific date elsewhere in the model, yes, but not in a generic sense..

[Sep2013]

Thnx blom. I have a date dimension.. And i am trying to use a filter as
Month= datepart(month,current_date) and date= datepart(date,current_date)

But when i drag it in my workspace advanced report, it throws error

[MFGF]

Hi,

Try using Cognos syntax, eg:

[Month] = extract(month, current_date)

MF.

[Sep2013]

Worked.. Thanks MFGF...