Hi All,
I have a requirement as follows. When i run the report studio report it should always run for the current date.
How shall we create a parameter map for current date in FM using the period field from the QS. Any function for this?
Appreciate a quick help. Thanks
Hi,
I have a question.
When u say default it should run for current_date, would there be any possibility of selecting other dates to run from the date prompt in the prompt page if any.
Do u want to schedule the report always run for current date?
Regards,
McMohan
Hi Mcmohan,
I have a date field in FM named period (mm/dd/yyyy). I want the report to run by default for current date ie today. I do not have any date prompt in the report. I want to create a period key (should contain todays date) in parameter maps and use in the report as a filter. What would be the calculation at the FM side?
thanks..
If you always want the report to run for the current date then you don't need to do anything in FM. You can create a filter in the report as under -
[Date] = current_date
[Date] will be the query item from the query subject that you will be comparing it to.
current_date is a cognos function available in Report Studio that returns the current date.
If you want this in Query Studio or elsewhere then you can do this in FM -
Create another query item in the query subject that has the Dates .
If ([Date] = current_date) then ('Current Date') else ('Not Current Date'). Name this query item 'Current Date'
In the studios, create a filter to say - [Current Date] = 'Current Date'