Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  How to test a report?

    Posted 06/19/19 04:34 AM
    Edited by System Admin 01/20/23 04:21 PM
    Hello,
    I'm thinking how do we should test a reports? I mean some kind of regression test to verify if a report is runable, if contains numbers etc. Of course I'm looking for the way how to do it automatically :)
    How do you do it? Do you have any idea?
    Thanks,

    ------------------------------
    Lubomir
    ------------------------------
    #CognosAnalyticswithWatson


  • 2.  RE: How to test a report?

    Posted 06/19/19 07:03 AM
    For setting up regression testing you could use Life Cycle Manager which is provided with the CA install https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_upgr_mngr.doc/c_um_upgr_mngr_obj.html
    If you want a more production ready product you could use MotioCI which also include version control and a very sophisticated testing component https://www.motio.com/products/ci/overview

    ------------------------------
    NORBERT Bracke
    ------------------------------



  • 3.  RE: How to test a report?

    Posted 06/20/19 09:59 PM
    We use the Cognos SDK as the basis for an integration test suite.

    The testcases login with users in the expected role, then execute the reports in their various output formats (HTML, PDF, Excel, Excel Data, etc) , and finally execute a number of assertions against the output files (we don't test PDF output for a number of reasons) .

    For Excel, we use Apache POI to read the spreadsheets and iterate through the sheets, rows, and cells.

    ------------------------------
    Denilson Nastacio
    ------------------------------