Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    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
    • Was this article helpful?
    //doorbell.io feedback widged