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

need to run the report for 1st -15 days and not for 16th

Started by msailaja484, 24 Oct 2017 03:06:48 AM

Previous topic - Next topic

msailaja484

Hi all i have a report which needs to get run from every month 1st-15th and from 16th the report need not to have run

msailaja484



in the filter  i had like this

[Reporting View].Open Date/Time(UTC/GMT)] between (cast(_first_of_month(current_date),timestamp)) and (_make_timestamp (extract (year , current_date), extract (month,current_date), extract (day, current_date))).

I heard that we can do from event studio , can anyon eplease help me as i need to run the report from 1st-15th everyday , and need to restrict from 16th
how?

BigChris

Yep, it sounds like Event Studio is the way to go here. You need to create an event that looks for something like day(current_date) between 1 and 15 and then have your report as the task after that.

msailaja484

Hi ,
Can you please specify the condition we need to giv ein event studio
The cataula requirement is the report has to get run  everyday from 1st- 15th  date as the data is very huge, thats why we need to split the report like that
i kept the condition as
day(current_date) between 1 and 15
But it not worked, Can anyone please help

BigChris

QuoteBut it not worked
In what way did it not work?

New_Guy

Hi,
Try using the below
current_date >= _first_of_month(current_date) and current_date < _add_days(_first_of_month(current_date),15) and [ONE] = 1
Create the data item [ONE] with 1 in it.
Schedule the event studio report by day if you want it every day or by week if you want the report only on week days. Let us know if you have any questions.
Good luck
New guy