Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Embedded report slow to render

    Posted Fri January 17, 2020 11:50 AM
    Dear all,

    In way, I have a similar issue as for this topic: https://www.ibm.com/mysupport/s/question/0D55000005sNF8YCAW/cognos-analytics-report-execution-through-url-slow

    The situation is that I try to embed very small reports in IFrames, in another HTML report. On the DB side, the time to retrieve the data is really really short, and they are quite simple (especially for this test); only one list with few columns, nothing complicated.
    Despite this, rendering this reports in a IFrame is too slow to be acceptable. Looking with the Chrome debugging tool, it appears that for each IFrame, Cognos is loading a lot of resources before even processing the report itself.
    Is there a way to avoid this?

    Thanks!

    KR

    ------------------------------
    Cosme POUSSET
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Embedded report slow to render

    Posted Fri January 17, 2020 03:01 PM
    Can you try main report as Non-interactive report and use iFrames to link to other reports to see the differences?

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

    Original Message


  • 3.  RE: Embedded report slow to render

    Posted Wed January 22, 2020 03:54 AM
    Hi Buddhi,

    Thanks for the answer.
    I tried this, but it is not possible currently as I'm using also some Custom Controls, which seems to require full interactivity.

    ------------------------------
    Cosme POUSSET
    ------------------------------

    Original Message


  • 4.  RE: Embedded report slow to render

    Posted Wed January 22, 2020 08:03 AM
    Edited by System Admin Fri January 20, 2023 04:43 PM
    Using custom controls for?
    If you really need the custom controls and cannot externalize your "program" it will be hard to eliminate "all the overhead".

    If you could put your custom control logic somewhere else, then you could use the REST-API to eliminate any "overhead" from interactive portal - like loading icons, fonts, javascripts, ....

    For example to run and retrieve a report with reportID: "i0D837BEE13B741709DF4576372FEEB32"

    http://localhost/cognos/bi/v1/disp/rds/reportData/report/i0D837BEE13B741709DF4576372FEEB32?fmt=HTMLFragment

    Retrieving reports previsouly saved report outputs are even faster to fetch, but you would need three requests to get there (so, there is some prefetching and XHR programming involved):

    (A) GET URL for latest report versions

    https://localhost/internal/bi/v1/disp/repository/sid/cm/rid/i2C32069702994AFDA4A2B99D53C622D4

    --> returns the URL to get (B) - the URLs with latest report output + format

    (B) Get URLs to retrieve latest report Output

    https://localhost/internal/bi/v1/disp/repository/sid/cm/rid/i2C32069702994AFDA4A2B99D53C622D4/vid/iD10C8E77819849DCBE0DD4D46C7B2613

    --> returns URLs with latest report version for different formats

    • XML
    • http://localhost:80/internal/bi/v1/disp/repository/sid/cm/oid/i8c0be20f2f7c4d35907af3676149672f/content
    • HTML
    • http://localhost:80/internal/bi/v1/disp/repository/sid/cm/oid/i76dba0777b5646f48687a191f71c7885/content
    • CSV
    We filed an Enhancement Request to deliver latest output version in just one single request and have the logic described above being executed on server-side. https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=123316 ... please, be encouraged to vote for it.

    Documentation of REST-API:
    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ca_dg_sdk.doc/c_dg_sdk_repositoryapireference.html

    Sidenote:
    "How to build really fast reports" was presented at the IBM Universtity in Miami 2018 and Think 2019 in San Francisco .

    Here is a sample report / dashboard with obfuscated data: http://more.amvara.rocks/

    - fetches 4 cognos reports and renders the data nice and sleak on any device
    - you can use it on you phone, tablet and desktop alike
    - First meaningfull paint in 0.2s
    - Fully interactive in 1.2seconds

    Hope this helps.

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

    Original Message


Related Content