Thanks Torben. I thought about that but wasn't sure I wanted to open up a folder on the server side for these files. I was really hoping that Jupyter could access the windows file system and make the spreadsheet update process easier. In this new world, nothing is really easier just different.
Great idea, I'll give it a try.
Scott
Scott Taylor
Cognos Administrator | Senior BI Analyst
Original Message:
Sent: 5/25/2020 3:51:00 AM
From: Torben Noer
Subject: RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham
Hi Scott
The Jupyter Notebooks runs as Linux inside a Docker container, so it can't see your local windows drive.... you would need to use a network drive or an url... I guess the simple thing here would be to create a subfolder under the Webcontent folder on your CA installation where you can upload files to.... then it's readable from CA and Notebooks as an url...
Torben
------------------------------
Torben Noer
------------------------------
Original Message:
Sent: Tue May 19, 2020 06:41 PM
From: Scott Taylor
Subject: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham
Janne,
Thank you for this example, it's exactly what I asked for. I wondering if its possible to read the file from a local drive. I know I've looked at the 'Current Working Directory' in the notebook, which comes back as '/home/ca_user' but I can't seem to find that location. So being able to point at a local drive doesn't seem possible or else I'm missing something.
Again, thanks for the example. Much appreciated.
------------------------------
Scott
Cognos Administrator
Wenatchee WA
Original Message:
Sent: Tue May 19, 2020 03:16 PM
From: JANNE LIND
Subject: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham
Thank you Matt and Rachel for your session.
I promised to provide an example to a participants on how to automate Excel update using Jupyter Notebook integration within Cognos Analytics.
1. Create Notebooks that loads data from Excel to Cognos Analytics.
Here is very simple Python example that loads Excel file from Website.
# We use pandas dataframes to store Excel data before uploading to data set.
import pandas as pd
# Loading Excel data from website to a Panda dataframe
df = pd.read_excel('http://biostat.mc.vanderbilt.edu/wiki/pub/Main/DataSets/titanic3.xls')
# Write data from Panda data frame to Cognos Data Set mode 'w' is for replace, mode 'a' is to append.
CADataConnector.write_data(df, path=".my_folders/Titanic Data Set", mode='w')
------------------------------
JANNE LIND
Original Message:
Sent: Thu May 14, 2020 10:46 AM
From: RACHEL SU
Subject: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham
I'm Rachel Su, Offering Manager, Cognos Analytics, IBM. My fellow OM and colleague, Matthew Denham and I will be leading a technical session, on May 19, from 2-3pm ET:
______________________
Interactive dashboards, reports and storytelling with Cognos Analytics
All organizations use dashboards and reports to present data, and business users shouldn't require specialized database or graphics design skills to create compelling visualizations. We've done that hard work for you so content creators don't need to.
______________________
Please share any thoughts or questions here in the thread, and we'll make sure this is available to you after the event so you can watch the replay and share your questions directly with us. In the meantime, would love to hear a little bit about yourself and what you'd like to get out of our User Group event. Drop a line in the thread below!
You can find all of the AMA threads here.
------------------------------
Rachel Su
Senior Offering Manager
Data and AI
IBM
------------------------------
#CognosAnalyticswithWatson