Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Cognos 11.0.x - how to tell when a report was last modified?

    Posted Thu November 18, 2021 04:20 PM
    Hello - is there anything in Cognos, perhaps the underlying Content Store DB, that would indicate when a report was last changed and by whom? I see the Date Modified in the UI but it's updating every day since the report is scheduled to run daily. This is causing us to get many questions from both internal & external auditors. Thank you in advance for any insight!


    ------------------------------
    Brad Chance
    BI Developer
    Park National Bank
    Newark OH
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos 11.0.x - how to tell when a report was last modified?

    Posted Fri November 19, 2021 04:59 AM
    Hi Brad, 

    This technote specifies what actions update the Modified Date of a report. 
    https://www.ibm.com/support/pages/what-actions-update-modified-date-cognos-connection

    As to my understanding, there is no easy way to tell the date when the report definition was modified. You use the Audit package and look at the Actions information which will show the history of actions performed on the object (report, in this case), see if you can create a report with required filters to get that information. 

    Regards,

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------

    Original Message


  • 3.  RE: Cognos 11.0.x - how to tell when a report was last modified?

    Posted Fri November 19, 2021 10:33 AM
    Thank you, Kiran for this information. I will take a look at the Audit package to see what information I can obtain. I'm a little surprised it's not easier to tell when a report definition was actually modified. I hope IBM will consider exposing this in a more straightforward manner in future releases.

    ------------------------------
    Brad Chance
    BI Developer
    Park National Bank
    Newark OH
    ------------------------------

    Original Message


  • 4.  RE: Cognos 11.0.x - how to tell when a report was last modified?

    Posted Wed November 24, 2021 03:32 AM
    Hi Brad,

    My answer is based on v11.2.1 but you wrote: "I hope IBM will consider exposing this in a more straightforward manner in future releases."

    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

    Best regards,



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

    Original Message


  • 5.  RE: Cognos 11.0.x - how to tell when a report was last modified?

    Posted Thu November 25, 2021 07:41 AM
    The macro function Patrick referenced was introduced for datasets.​  Potentially in the future if may be expanded for other usage and properties.

    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message


  • 6.  RE: Cognos 11.0.x - how to tell when a report was last modified?

    Posted Fri November 26, 2021 02:17 PM
    Edited by System Admin Fri January 20, 2023 04:44 PM
    If Auditing is is enabled in your environment you can find this information in the Audit Report named 'Operations by selected object and users'.

    Answer prompts:

    Select operation(s) = UPDATE
    Select Object(s) = REPORT
    Select user(s) = optional

    https://www.ibm.com/support/pages/node/6507399

    ------------------------------
    DEAN BLACK
    ------------------------------

    Original Message