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.  Create batch file or other process to run consecutive reports for testing

    Posted 01/15/20 03:44 PM
    ​We are on Cognos Analytics 11.0.10 We are in the process of upgrading our SQL severs.  I need to test 20 or so reports to see how performance is, etc.  I'd like to be able to run these one after another without having to manually complete the report prompts for each report one at a time and then run the reports.  Wanted to see if there is a way to set up a scenario that would be more in line with multiple users running report interactively at the same time. Any idea if a batch file could handle this situation or if there is another way to accomplish this?

    ------------------------------
    Betina Stapleton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Create batch file or other process to run consecutive reports for testing

    Posted 01/16/20 03:09 AM
    That sounds like you need to create a Job within Cognos. You can add various report to the job, set it to run all at once, then schedule it to run.

    ------------------------------
    Chris Turner
    ------------------------------



  • 3.  RE: Create batch file or other process to run consecutive reports for testing

    Posted 01/16/20 09:46 AM
    I would also recommend a Job but you can try using a Trigger as well. You add a Trigger name to the report in the schedule area and use the Trigger.bat / .sh file in the \webapps\utilities\trigger directory.

    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 4.  RE: Create batch file or other process to run consecutive reports for testing

    Posted 01/16/20 10:53 AM
    Hi,

    We use Cognos SDK or jMeter for that purpose.

    https://jmeter.apache.org/

    Hope that helps.

    Best regards,  
      Ralf

    ------------------------------
    Ralf Roeber
    Managing Partner
    Amvara Consulting
    El Masnou
    ------------------------------



  • 5.  RE: Create batch file or other process to run consecutive reports for testing

    Posted 01/16/20 10:53 AM
    We use Cognos SDK or jMeter https://jmeter.apache.org/ for testing.

    ------------------------------
    Ralf Roeber
    Managing Partner
    Amvara Consulting
    El Masnou
    ------------------------------



  • 6.  RE: Create batch file or other process to run consecutive reports for testing

    Posted 01/16/20 11:05 AM
    We use jMeter for performance and also functional testing. It lets you record a click path, define threads for simulating parallel users clicking, each execution is logged and depending on your settings when jMeter test finishes it automatically creates a dashboard with the results.


    In the graph you can see:
    * Rampup time is 5 minutes, the login sequence for the 100 users starts at 21:08 and stops at 21:14 
    * Queuquing starts around 70 parallel users
    * No errors in executions over time
    * Min and Max response times for distinct reports
    * Evolution of response times when more and more users execute in parallel
    Mail me, if you would like more information or a screensharing for getting jMeter to run your first testcase.

    see http://jmeter.apache.org/
    and https://www.ibm.com/mysupport/s/question/0D50z00005q4E39CAE/anyone-succesfully-configured-jmeter-for-cognos-11-performance-testing-yet

    ------------------------------
    Ralf Roeber
    Managing Partner
    Amvara Consulting
    El Masnou
    ------------------------------



  • 7.  RE: Create batch file or other process to run consecutive reports for testing

    Posted 01/16/20 01:12 PM
    Betina, since you are still in an 11.0 environment, you might be able to use Lifecycle Manager for the load test https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_upgr_mngr.doc/t_exe_reports.html

    ------------------------------
    Albert Valdez
    albert@intelalytics.com
    ------------------------------



  • 8.  RE: Create batch file or other process to run consecutive reports for testing

    Posted 01/16/20 02:26 PM
    ​Thank you for all of the suggestions. I'm going to just run several jobs containing multiple reports that run at the same time.  Sometimes I just overthink how to do things! :)

    ------------------------------
    Betina Stapleton
    ------------------------------