• Product: Aleph
• Product Version: ARC 2, 3
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Question    
Is there a way to run an ARC report once per week or month and include only the past week/month in the report?

Answer    
The periods are defined in the table PRC_CAPTION_LANGUAGE.
This table is being built during ETL (with values hard coded in the Cobol programs).
These are the contents of this table: 

usmr0@CRN> select CAPTION_NAME from PRC_CAPTION_LANGUAGE;
**** Hit return to continue ****

CAPTION_NAME
--------------------------------------------------
morning
noon
evening
night
1
2
3
4
5
6
**** Hit return to continue ****

CAPTION_NAME
--------------------------------------------------
7
lastweek
lastmonth
lastquarter
lastyear

Additional Information
A possible example for defining the last month could be the following definition. 

[Budget Presentation Layer].[Orders].[Order Date] between _first_of_month(_add_months(current_date,-1)) and _last_of_month(_add_months(current_date,-1))

You might look up the actual report query in Report Studio by clicking on 'XML' (Show specification) and use it as an example for new reports.

• Article last edited: 26-Jun-2016