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

prompt macro help

Started by COGNOSBC, 20 Jun 2013 11:38:02 AM

Previous topic - Next topic

COGNOSBC

could you please help me in below thing:

how to incorporate following filter using prompt macro:(because my report is based on sql. I have added this filter in the query for it is taking long time to produce the results. so I want to put this filter in the sql only using prompt macro and  see how long it will take. I am sure prompt macro does not take longer time)

(?dateRange?='P'  and
[Data Item1] = _add_days(current_date, -1))
or
(?dateRange?='P3'  and
[Data Item1] between( _add_days(current_date, -3)) and ( _add_days(current_date, -1)))
or
(?dateRange?='P4'  and
[Data Item1] between( _add_days(current_date, -4)) and ( _add_days(current_date, -1)))
or
(?dateRange?='PW'  and
[Data Item1] between( _add_days(current_date, -7)) and ( _add_days(current_date, -1)))

COGNOSBC

can I get any help please..