Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  D3.js IBM Cognos Analytics library

    Posted Thu January 23, 2020 03:41 AM
    Hello Community,

    Do Somebody know where i can find some documentation about D3.js IBM Cognos Analytics library?
    (Intallation guide, Library Guide, Examples...)

    Thanks in advance,
    Best Regards.

    ------------------------------
    Robert Berchtold Palacios
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: D3.js IBM Cognos Analytics library
    Best Answer

    Posted Thu January 23, 2020 04:54 AM
    see https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.dg_custom_vis.doc/ca_custom_visualizations_intro.html
    for some introduction to D3 setup and customization.

    After fidling around with D3 we decided to go for extra simple reports providing data on cognos side. These reports are provided by the business department, as they know their data better. The visualization and logic is completly outside cognos (but still on the cognos server leveraging hardware and security infrastructure). We went for angular and ngxcharts.

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



  • 3.  RE: D3.js IBM Cognos Analytics library

    Posted Thu January 23, 2020 06:27 AM
    Just found a very nice video  from Ed Gonzalez.
    He was so nice to share the code in github

    Just a few thoughts:

    To levarage the benefits from cognos portal like navigating, exploring data, sharing, alerting, bursting and consuming and adhoc queries and and and -> needs the whole Cognos Code, Icons, Fonts, libs, ... so stay here integrate D3 as Ed Gonzalez did.

    If the consumer just wants to consume some specific information from lets say 10 reports, it might be worth trying to eliminate any overhead from the portal in order to drastically speed everything up to a completly next level. Howto do that? Create angluar application fetching data via REST from cognos server as csv, html or xml. visualize the data as soon as it has been fetched within milliseconds using external libs like D3 or ngxcharts. Using serviceWorkers in angular you can make your dashboard/reports available offline.

    Just as Ed said in his video ... going either way needs knowledge in javaScript.

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



  • 4.  RE: D3.js IBM Cognos Analytics library

    Posted Thu January 23, 2020 06:43 AM
    Before you start with the IBM d3 implementation, it is a good idea to read up on how d3 actually works. A lot of people find it really difficult, so having a basic understanding will really help you down the way.

    The payoff is that d3 is extremely powerful, there is not much that you can not visualise with it, and being able to write your own d3 visualisations for Cognos basically allows you to show your Cognos data in any way you can imagine.

    And beyond that, you are not limited to implement your custom visualisations in d3, you can use any javascript (library) and generate the html and css you want.

    I did some implementations myself, and was able to build custom maps using Leaflet (using Geo data, polygons even, stored a database), I built process flows to do processmining, and I created a visualisation that lists Cognos objects from a list of objectsIds, which you can use to show your last updated or most popular objects. And only the processmining visualisation is loosely based on d3 (via a library that used d3, so I didn't have to deal with it )

    Good luck!


    ------------------------------
    Reinier Battenberg
    https://github.com/CognosExt
    ------------------------------



  • 5.  RE: D3.js IBM Cognos Analytics library

    Posted Tue January 28, 2020 05:53 AM
    Hi Robert

    There are 2 ways to include D3 visualizations - the other answers in this thread refers to both of them...

    The old way (pre 11.1.4) was to use custom controls in Reporting to bring in your Javascript based visualizations
    The new way (from 11.1.4 and both in Reporting and Dashboarding) is to use the new Custom Visualization  functionality.  I would recommend you to download some of the samples from here: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ig_smples.doc/c_sample_customvis.html
    Look at the step-by-step guides on  how to build your own:
    Copy a D3 Collision viz: 
    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.dg_custom_vis.doc/ca_customviz_tutstepbystepintro.html
    Scatter step-by-step: 
    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.dg_custom_vis.doc/ca_customviz_lib_tutorialscatter0.html
    and then, if you want to continue developing your own D3 custom visualizations, you would need JavaScript and D3 coding skills...
    One of the recommended books are: 

    https://learning.oreilly.com/library/view/interactive-data-visualization/9781491921296/

    Torben



    ------------------------------
    Torben Noer
    ------------------------------