ARC report with just past week or month
- 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