Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Experts advice on performance improvement tips for Long running reports

    Posted Fri March 08, 2024 10:36 AM

    Hello Analytics Team, 
    I am seeking your expert advice to enhance the performance of some long-running reports. Before I delve into the analysis, I would like to gather your valuable inputs and suggestions that can greatly aid my performance improvement analysis.

    Thank you in advance for your assistance!



    ------------------------------
    Yugandhar Jebiti
    ------------------------------



  • 2.  RE: Experts advice on performance improvement tips for Long running reports

    Posted Sun March 10, 2024 05:14 AM

    Hi Yugandhar,

    This is with everyone who has not properly managed the joins on the DataModule, database table properties or queries within the cognos environment. In some of the cases the performance improvement may be a challenge from the problem complexity stand points but the required performance criterions can be achieved with many methods, like optimising joins, optimising db params, change the to materialised views, making different ways of filters.

    Refer one of video which demonstrates how we achieved significant performance with custom filter conditions,

    https://www.youtube.com/watch?v=Apx9vG5yu7A

    Let us know if need any deeper understanding on the same.



    ------------------------------
    Jacky Patel
    Director Analytics Solutions
    Veracitiz Solutions Pvt Ltd
    Navi Mumbai
    +919167755646
    ------------------------------

    Original Message


  • 3.  RE: Experts advice on performance improvement tips for Long running reports

    Posted Mon March 11, 2024 06:10 AM

    Hi, From general to single report specific performance issues I recommend to check the following: 

    • Check proper hardware sizing and configuration if generally slow 
    • Use aggregated and/or reduced tables (or data sets) if data size is an issue 
    • Avoid local processing of queries if a sinlge data source is possible 
    • Use query optimization if multiple data sources are neccessary 

    For query analysis it's helpful to check and compare Cognos SQL and Native SQL. Possibly the SQL doesn't look efficient or Cognos SQL and Native SQL differ decisively. Sometimes a database function is used that is not supported (properly) by Cognos and local processing is used without need. In many cases report performance can be increased significantly by replacing single functions or by (slightly) adjusting the data model or report. 



    ------------------------------
    Philipp Hornung
    Business Intelligence Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------

    Original Message


  • 4.  RE: Experts advice on performance improvement tips for Long running reports

    Posted Mon March 11, 2024 09:22 AM
    Edited by Marc Reed Mon March 11, 2024 09:31 AM

    https://www.redbooks.ibm.com/redbooks/pdfs/sg248121.pdf

    Page 67 onwards...

    and 

    Include performance details when running reports to find the slow bits

    ------------------------------
    Marc Reed
    ------------------------------

    Original Message


  • 5.  RE: Experts advice on performance improvement tips for Long running reports

    Posted Mon March 11, 2024 11:49 PM

    The discussion around page 78 references an old approach to eliminate branches of expressions.

    For several years, during query planning Dynamic Query will apply a concept called constant folding. Meaning, where applicable the engine will determine if parts of an expression can be rewritten/simplified. While they may help to reduce runtime cost, always prudent to review if the logic as-written supports dated requirements. Similarly, where the pattern of switching in expressions via parameter maps appropriate and so forth.

    A meaningless example of an expression which can be re-written to SNO = 'P1'.





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

    Original Message


  • 6.  RE: Experts advice on performance improvement tips for Long running reports

    Posted Mon March 11, 2024 09:31 AM
    Edited by TREVOR COMEAU Mon March 11, 2024 09:32 AM

    Hi Yugandhar,

    If you go to youtube there is a 5 part series under this title.IBM Cognos Analytics Proven Practices - Designing Reports for Performance

    It is based on using Framework Manager and from a few versions back but gives a lot of solid advice that will still be relevant.

    Cheers,



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

    Original Message