Cognos Analytics

 View Only

  • 1.  data refresh

    Posted Mon January 30, 2023 09:21 AM
    Hi all,
    is there a way to see on GBSAT reporting folder the date of Cognos data refresh and/or receive refresh notifications?

    ------------------------------
    Patrizia Patania
    ------------------------------


  • 2.  RE: data refresh

    IBM Champion
    Posted Mon January 30, 2023 11:11 AM
    Hi Patrizia,

    The assetProperty function (new in v11.2.1) returns the property of an asset. If the property is not specified then the modification time is returned. 
    The assetProperty function

    Note: this asset should be a dataset.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message


  • 3.  RE: data refresh

    IBM Champion
    Posted Mon February 06, 2023 02:55 PM
    Edited by Logan Whitaker Mon February 06, 2023 02:56 PM
    Another approach is to simply add the CURRENT_TIMESTAMP to your dataset.  When the refresh is run and the data cached, the records will have the timestamp on it.

    ------------------------------
    Logan Whitaker
    ------------------------------

    Original Message