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?
Yes and no.. For a specific date elsewhere in the model, yes, but not in a generic sense..
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
Hi,
Try using Cognos syntax, eg:
[Month] = extract(month, current_date)
MF.
Worked.. Thanks MFGF...