Cognos Analytics with Watson

 View Only

Script in Python against governed Cognos data - Notebooks

By KASUN ATTANAPOLA posted Fri April 26, 2019 03:52 PM


Cognos 11.1.2 now gives users the ability to script, run and share Python code against governed Cognos data via a new capability called 'Notebooks'.

Enabling python scripts within the Cognos ecosystem has significant value:

  • Advance data analysts can script against governed and centralized data (Single version of the truth)
  • Report authors can build reports shaped and transformed (ETL) by Python scripts
  • Report authors can embed functions, custom visualizations etc. created by advance data analysts
  • Advance data analysts can schedule and share their assets with other BI users with the right security, permissions and governance
  • Empower all BI users with advanced predictive analytics

Check out the video below to learn about all the new Notebook features and capabilities!


Notebooks requires a Jupyter server to be installed. This server can be installed on the same machine as the IBM Cognos Analytics server or on a separate one. Once the Jupyter server is set up, users executing Python would be sandboxed into their own environment via containerization as an added security measure. Additionally, containerization would easily allow for server scalability to accommodate traffic and offer a standardized Production-level Python environment for all permissioned users.

Check out the following five-part video series to learn about installing and configuring the Notebooks server. Note that the Notebook Server installer and Server repository are found only in the Linux eAssemblies. To access Notebook install documentation please click here.

Cognos Notebooks install – Part 1 (Fresh install of Jupyter Server)

Cognos Notebooks install – Part 2 (Securing the Jupyter Server)

Cognos Notebooks install - Part 3 (Adding Python Packages)

Cognos notebooks install – Part 4 (Upgrading to the latest Jupyter Server)

Cognos Notebooks install – Part 5 (Connecting a Notebooks server to IBM Cognos Analytics)


Stay tuned for more Notebook capability updates in future releases!




Fri June 07, 2019 08:14 AM

Not only Ubuntu, I installed it on CentOS then I thing it work fine in major part of Linux distributions. Potentially it's possible to install it in Windows (I presume) but it's complicate & there is not reason to do it.

Fri May 10, 2019 02:55 PM

Hi Nick,

My idea is because IBM package a specific version of Jupyter. If you're looking at OnPrem 11.1.2 files Jupyter is packaged as a docker app.

Maybe a way could be to try to install the Jupyter Docker app on a Windows Container. Maybe it will run.

On my part I trying to my Windows Anaconda environment with no success.

Fri May 03, 2019 10:03 AM

If Cognos Analytics relies on a URL to connect to a Jupyter notebook server - why can't I run this via Windows ?.

Mon April 29, 2019 01:46 PM

Hi Martin,

Yes, the Notebooks server must be installed on an Ubuntu Machine.

Thank you,

 - Kas

Mon April 29, 2019 10:53 AM

Hi Kasun,

is it mandantory to install Jupyter Notebook on Linux?
Can I integrate a anaconda-Jupyter Notebook on Windows?