Parameter Maps in FM

[adoremars]

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

[Mpotla]

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

[adoremars]

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

[cognostechie]

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'