List of Contributions

Scott Taylor

Chelan County PUD

Contact Details

Chelan County PUD

My Content

1 to 20 of 50+ total

RE: Authentication stops working for certain users

Posted By Scott Taylor Fri February 05, 2021 06:20 PM
Found In Egroup: Cognos Analytics \ view thread
Robert, I got a response from IBM Support stating I should make the following changes in Cognos Configuration. Under Advance properties of the namespace add the following: handleExpiry=600 cacheTimeToLive=300 cacheSize=1048576 save and restart service. I will have to wait until after ...

RE: Authentication stops working for certain users

Posted By Scott Taylor Thu February 04, 2021 07:37 PM
Found In Egroup: Cognos Analytics \ view thread
Andrew, Thanks for this information. I remember your article and have on a regular basis checked the BIN and BIN64 folders for dump files. This time I did not find any, nor any of the other files you suggested. Since I have a primary and standby content server, I switched them to see if they ...

RE: Authentication stops working for certain users

Posted By Scott Taylor Thu February 04, 2021 01:37 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks for the idea Andy, I was successful in saving the configuration. Checking for errors and configuration integrityGenerating cryptographic informationChecking integrity of encrypted dataChecking upgrade status No issues were noted. I have found that when the authentication has stopped ...

RE: Authentication stops working for certain users

Posted By Scott Taylor Wed February 03, 2021 03:03 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks for the ideas Robert. Just wondering where in the admin console you would see the Java usage? Each of our two Cognos servers have 8 cores and 32 GB ram which I would think shouldn't be an issue. After I posted the question I had another day that the authentication stopped working for my service ...

Authentication stops working for certain users

Posted By Scott Taylor Mon February 01, 2021 07:19 PM
Found In Egroup: Cognos Analytics \ view thread
I have a service account that I used for building cubes on a tools server. The account authenticates to our Production environment (11.1.7 FP2) nightly during the build process. Recently this account stops being authenticated by Cognos and the cubes fail to build. The account hasn't been locked out in ...

RE: REST API error when connecting to OData source

Posted By Scott Taylor Wed December 02, 2020 12:30 PM
Found In Egroup: Cognos Analytics \ view thread
Just wanted to let all know that we solved this problem. First there were additional changes needed in our firewall for the Cognos server. Then when we tested again we received a 401 error. Searched IBM and found that we need to add 'AuthenticationMethod=basic' to the Connection properties. Doing this ...

REST API error when connecting to OData source

Posted By Scott Taylor Mon November 30, 2020 07:32 PM
Found In Egroup: Cognos Analytics \ view thread
We are testing the REST API against an OData source. I've connected to this source on my desktop web browser and it returned .json content. When I set up the connecting in Cognos I receive the following when I test it. This is the URL (without UN/PW) that we were testing in the data source connection: ...

RE: Shared image folder on network drive, is it possible?

Posted By Scott Taylor Tue October 20, 2020 11:39 AM
Found In Egroup: Cognos Analytics \ view thread
Thank you to everyone who responded to my request for help. I reviewed the extension idea and it didn't address the question I had. I appreciate the information though. I think I figured out what would work best for us. We'll use a shared folder for holding images (only authorized BI users can write ...

RE: Shared image folder on network drive, is it possible?

Posted By Scott Taylor Fri October 16, 2020 01:05 PM
Found In Egroup: Cognos Analytics \ view thread
I understand about the Media extension but my question was about the multi-server setup. With 2 content manager servers 'can' i have one folder for all my images or are you saying I need to duplicate images on both machines. I want to have a shared folder that users (specific users) that can add images ...

Shared image folder on network drive, is it possible?

Posted By Scott Taylor Thu October 15, 2020 07:26 PM
Found In Egroup: Cognos Analytics \ view thread
I'm new to multi-server setup for Cognos Analytics. Most of my images I've used in dashboards have been saved in the "webcontent/bi/samples/images" folder but now with a primary CM and standby CM server I like to have a single location for all images. Is it possible to use a network folder for all images ...

Adding 2nd application server

Posted By Scott Taylor Thu July 09, 2020 07:42 PM
Found In Egroup: Cognos Analytics \ view thread
In my test environment I have a primary CA 11.1.6 server with Gateway, application tier, and CM installed. I've also have a second CA 11.1.6 server with application tier, and CM installed. This is the standby CM server. I've set up the URLs on both servers to list out the primary server first and the ...

RE: Invalid login installing SSO using scripts provided.

Posted By Scott Taylor Fri June 26, 2020 12:22 PM
Found In Egroup: Cognos Analytics \ view thread
I had something similar with this release. Could not get SSO to work. In my case it was a single server install. Solve the problem with the fix pack IBM released. Everything worked great after that. Scott Scott Taylor Cognos Administrator | Senior BI Analyst

User receives AAA-SYS-0001 error while logging in

Posted By Scott Taylor Wed June 10, 2020 06:48 PM
Found In Egroup: Cognos Analytics \ view thread
I hope one of the experts online can help with this. I have a user logging into CA V11.1.3 and they receive 'AAA-SYS-0001 An internal error occurred' message on IE and also on Edge (chromium). Our server is Windows Server 2016 with 32 GB of Ram. Currently the ram usage is at 44% so I don't think its ...

RE: 'IBM Cognos for Microsoft Excel' (CAFE) >> URLs for TM1

Posted By Scott Taylor Tue June 09, 2020 12:45 PM
Found In Egroup: Cognos Analytics \ view thread
Jean, Why would you download and use CAFÉ? IBM stopped supporting this product well over a year and half ago. I used it for almost 20 years but then IBM pushed us to use PAX. We've converted all our users to PAX (2.0.43) although I miss the simple functionality of CAFÉ. Scott Scott Taylor ...

RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

Posted By Scott Taylor Tue May 26, 2020 11:55 AM
Found In Egroup: Cognos Analytics \ view thread
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 ...

RE: Jupyter notebook example to read network Excel file then save to CA

Posted By Scott Taylor Tue May 19, 2020 06:49 PM
Found In Egroup: Cognos Analytics \ view thread
Thank you for the quick reply and example. Definitely something I will try. I seem to forget that python is running in a docker instance within Ubuntu and not Windows. Your explanation makes sense to why it can't find the local drives. I did read about importing 'win32com' which gave you access to the ...

RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

Posted By Scott Taylor Tue May 19, 2020 06:41 PM
Found In Egroup: Cognos Analytics \ view thread
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 ...

Jupyter notebook example to read network Excel file then save to CA

Posted By Scott Taylor Tue May 19, 2020 03:03 PM
Found In Egroup: Cognos Analytics \ view thread
Based on todays User Group Days discussion, it looks like Jupyter notebooks is the only way to update Excel data files and refresh them on Cognos. I'm looking for an example that does that simply. Current examples only read downloaded files but I would like it to read network accessed files. Should be ...

RE: AMA: IBM Planning Analytics for Excel 2020 with Rebecca Hansen

Posted By Scott Taylor Tue May 19, 2020 01:33 PM
Found In Egroup: Planning Analytics \ view thread
Hello Rebecca. Any chance that the PAX product has been fixed for use with Cognos Analytics BI? The required 'refresh all' to get the PAX - Excel product to return accurate data from Cognos Analytics is still a pain. ------------------------------ Scott Cognos Administrator Wenatchee WA ---- ...

Trouble installing pypiwin32 package in Jupyter server

Posted By Scott Taylor Tue May 05, 2020 02:24 PM
Found In Egroup: Cognos Analytics \ view thread
I need to use the win32com.client with Jupyter Notebooks. I've added 'pywin32' to the additional_packages.txt file. When I run the install it comes back with "Could not find a version that satisfies the requirement pywin32==227. No matching distribution found for pywin32==227". I then tried pypiwin32 ...