Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Report Change Tracking

    Posted Tue February 11, 2020 05:19 PM
    Hello,

    I am looking to create a change control process when adding or updating reports within Cognos. In order to audit and review report changes, I am looking for a way to track the changes made. Is there a way to track changes with current Cognos 11 functionality or do I need to use a third party solution like Motio to track changes?

    Thank you,

    ------------------------------
    Brian
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Report Change Tracking

    Posted Wed February 12, 2020 10:26 AM
    If you can export report specifications using SDK or manually, you can do it using Git. For additional objects, probably using deployment zip file will be way to track changes in this method.

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 3.  RE: Report Change Tracking

    Posted Wed February 12, 2020 10:21 PM
    https://www.ibm.com/support/pages/cognos-toolkit-github-integration
    See it in action here:
    https://www.youtube.com/watch?v=r0yVU9MNW_I
    "For more information and to request a demo, contact diagtool@ca.ibm.com


    ------------------------------
    Luke Peterson
    Business Analytics Advocate
    IBM
    ------------------------------



  • 4.  RE: Report Change Tracking

    Posted Thu February 13, 2020 03:57 AM

    Hi Luke,

     

    That looks like a start. Are there more ambitions for this tool, eg, tagging & packaging of releases, allowing users to go back to previous commits, branching etc. Or will this tool just be a 'save to git' tool?

     

    And can you explain why the demo shows that all objects are stored as .txt in git, and not in .xml or .json? Is there any specific reason for this?

     

    Rgds,

     

    Reinier

     

     

    On donderdag 13 februari 2020 04:20:43 CET Luke Peterson via IBM Community wrote:

    www.ibm.com/support/pages/... See it in action here: www.youtube.com/watch?v=r0yVU9MNW_I "For more information and to request a demo, contact... -posted to the "Cognos Analytics" group

    Cognos Analytics

      Post New Message

    Re: Report Change Tracking

    Reply to Group

    Reply to Sender

    Feb 12, 2020 10:21 PM

    Luke Peterson

    www.ibm.com/support/pages/...
    See it in action here:
    www.youtube.com/watch?v=r0yVU9MNW_I
    "
    For more information and to request a demo, contact diagtool@ca.ibm.com

    ------------------------------
    Luke Peterson
    Business Analytics Advocate
    IBM
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  

    -------------------------------------------
    Original Message:
    Sent: Tue February 11, 2020 03:14 PM




     

    You are subscribed to "Cognos Analytics" as reinier@mountbatten.nl. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.



    ------Original Message------

    https://www.ibm.com/support/pages/cognos-toolkit-github-integration
    See it in action here:
    https://www.youtube.com/watch?v=r0yVU9MNW_I
    "For more information and to request a demo, contact diagtool@ca.ibm.com


    ------------------------------
    Luke Peterson
    Business Analytics Advocate
    IBM
    ------------------------------

    #CognosAnalyticswithWatson


  • 5.  RE: Report Change Tracking

    Posted Thu February 13, 2020 09:58 AM
    We can download report specs in xml format (SDK or manually) and add to git. Git doesn't restrict it. While updating anything, add change log relevant to your tracking.

    We can do comparison between commits using git bash command line tool. If have remote server like GitHub, BitBucket, you can also share with others and compare using Blame command.

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 6.  RE: Report Change Tracking

    Posted Thu February 13, 2020 02:01 AM
    Hi, 

    A direct integration with Cognos portal is only possible with paid tools like Motio CI, Cognos Toolkit etc. Or you have to build some kind of extension to integrate Git or any other source control by writing your own API method calls and calling them using javascript from the extension. The other way is to manually copy the specification to a file and using source control to track the file check in / check outs. 

    If you are just looking for audit information, you can find that from Audit Package / Reports that come with cognos samples. There is a report that shows actions on objects like Update, Delete, Add, Query etc. 

    Regards
    Kiran

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