List of Contributions

Jeff Jones

Contact Details

My Content

1 to 20 of 20 total

New Installation setup failover of application server

Posted By Jeff Jones Fri May 14, 2021 12:05 PM
Found In Egroup: Cognos Analytics \ view thread
As we look to install Cognos 11.2, thought I might experiment with failover in our Dev environment. I have a web server with the gateway installed, and then I have the Content and Application layers installed on a second server. Looking to set up a third server for the Content and Application for failover. ...

Data Modules in R7

Posted By Jeff Jones Wed February 10, 2021 01:32 PM
Found In Egroup: Cognos Analytics \ view thread
Hey all, So, I have an excel spreadsheet provided by the business that I'm blending with a package of data. I've decided to use a Data Module because it just makes sense to let the business user update their spreadsheet periodically, rather than put the data into a table and add it to the FWM model. ...

Dashboard in CA 11.1.5 now blank, not editable

Posted By Jeff Jones Wed October 28, 2020 11:17 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Dashboard in CA 11.1.5 now blank, not editable

Posted By Jeff Jones Wed October 28, 2020 11:17 AM
Found In Egroup: Cognos Analytics \ view thread
Hello all, Yesterday I was in this dashboard and it was working as expected. This morning I went in to view the dashboard and it opened, but was grey and blank, except the tabs were still present. I clicked on the Edit Icon, and nothing happens, The package doesn't show up and nothing seems to change. ...

RE: Chrome update disables Cognos Analytics functionality

Posted By Jeff Jones Tue October 13, 2020 10:31 AM
Found In Egroup: Cognos Analytics \ view thread
This morning, I worked with our user on this issue, and Firefox did end up working. Looks like our issue is in line with this one. I opened a ticket yesterday and amended with a note that Firefox is working. ------------------------------ Jeff Jones ------------------------------

RE: Chrome update disables Cognos Analytics functionality

Posted By Jeff Jones Mon October 12, 2020 05:24 PM
Found In Egroup: Cognos Analytics \ view thread
I just opened a support ticket for this, as I have a user experiencing the same issue. Originally we were upgrading to 11.1.7, but then that was paused until the issue with Google Chrome was resolved. Now suddenly I have users in 11.1.5 that cannot open folders/query subjects in packages as well, which ...

RE: Bar Chart Colors

Posted By Jeff Jones Thu September 10, 2020 03:56 PM
Found In Egroup: Cognos Analytics \ view thread
Awesome, I will take a look, thanks Rene! ------------------------------ Jeff Jones ------------------------------

Bar Chart Colors

Posted By Jeff Jones Wed September 09, 2020 12:49 PM
Found In Egroup: Cognos Analytics \ view thread
Hey All, Need some help on a bar chart in 11.1.5. We have a bar chart that if a percent is above 95% color the bar green, anything below 95% would be colored Red. In order to get the color green or red, I created a calculation that evaluates to 1 (above or = 95%) or 0 (below 95%). All good and ...

Maps in PDF or Excel

Posted By Jeff Jones Tue August 25, 2020 02:57 PM
Found In Egroup: IBM Business Analytics \ view thread
I am in Cognos 11.1.5 and I see the visualization for the Map is only used in HTML output, I have a report that currently has a map in it, and we are being asked to recreate it in Cognos. It's a PDF report. Curious if there is any way to get a Map visualization to show up in a PDF. Thanks for your ...

11.1.7 Folder Navigation

Posted By Jeff Jones Thu August 13, 2020 06:35 PM
Found In Egroup: Cognos Analytics \ view thread
I have installed the 11.1.7 version of Cognos Analytics in our Dev environment. So far so good, except today, I noticed that when I navigated the folders down to a lower folder, then went to a meeting. It logs you out after an hour, so I logged back in and I found that navigation was greyed out, and ...

Data Source Connection for GraphQL

Posted By Jeff Jones Thu July 09, 2020 12:54 PM
Found In Egroup: Cognos Analytics \ view thread
I am new to this type of connection and did a little googling but haven't found anything yet. Our organization utilizes Monday.com. They recently switched their API to a GraphQL API. In PowerBI, I have been able to connect using a JSON connection, but I'm not sure what Data source connection I should ...

RE: Filtering from the Insertable objects pane using a Data Module

Posted By Jeff Jones Tue June 30, 2020 11:11 AM
Found In Egroup: Cognos Analytics \ view thread
Just for a little more clarification on this. We are currently on 11.1.5, I am using Google Chrome. Below are two screenshots. The first image is from a package, I can right click on a particular data item in the Insertable objects pane and I have the ability to filter the report. The second image ...

Filtering from the Insertable objects pane using a Data Module

Posted By Jeff Jones Tue June 30, 2020 09:48 AM
Found In Egroup: Cognos Analytics \ view thread
Hey everyone, We are in the process of evaluating moving some of our frameworks over to data modules. We have created a new data module and since I'm new to them perhaps I over looked something, but when I use a framework created package, I can right click on a data element within the package in the ...

RE: Framework Manager DMR - Aggregation Rules

Posted By Jeff Jones Wed June 10, 2020 11:00 PM
Found In Egroup: Cognos Analytics \ view thread
Thank you Ian for the response. It makes perfect sense. I appreciate the detailed explanation! This gives me some food for thought in how I might be able to tackle this. Thanks again! ------------------------------ Jeff Jones ------------------------------

Framework Manager DMR - Aggregation Rules

Posted By Jeff Jones Wed June 10, 2020 04:37 PM
Found In Egroup: Cognos Analytics \ view thread
Hey All, I have an Inventory Cube that I am trying to replicate in FWM (eventually a Data Module if I can). My On Hand metric should not be rolled up but should be the last number for the month, or for the year, depending upon the time frame. I have created a Time Dimension that has a Year level, Quarter ...

Framework Manager DMR - Aggregation Rules

Posted By Jeff Jones Wed June 10, 2020 04:01 PM
Found In Egroup: IBM Business Analytics \ view thread
Hey All, I have an Inventory Cube that I am trying to replicate in FWM (eventually a Data Module if I can). My On Hand metric should not be rolled up but should be the last number for the month, or for the year, depending upon the time frame. I have created a Time Dimension that has a Year level, Quarter ...

RE: Data Modules and Relative Time

Posted By Jeff Jones Fri May 15, 2020 06:46 PM
Found In Egroup: Cognos Analytics \ view thread
Awesome! Unfortunately, mine was just pulling only that one in, but I think you're right, there must be something else going on. I did create a Fiscal Calendar using the provided sample report, because we're on a slightly different fiscal year. Perhaps that might be causing an issue. It was pretty easy ...

RE: Data Modules and Relative Time

Posted By Jeff Jones Fri May 15, 2020 08:59 AM
Found In Egroup: Cognos Analytics \ view thread
Sure, so I get this error when creating a report from the data module. It is one of the automatically generated measures when linking the fact table to the relative time table. What is interesting is the YTD measure works just fine.I've looked at the expressions these are built off of and I don't see ...

Data Modules and Relative Time

Posted By Jeff Jones Thu May 14, 2020 10:26 AM
Found In Egroup: Cognos Analytics \ view thread
Hey all, I am currently starting to evaluate heading towards developing Data Modules. In 11.1.5 I am currently building a Data Module and using the Relative Time feature. I have used it against a few measures and it's great because it does all the YTD, CY, PY, measures quickly. What I have noticed ...

RE: Add Existing IBM cognos report into DASHBOARD in IBM COGNOS 11.0.7

Posted By Jeff Jones Thu May 14, 2020 10:09 AM
Found In Egroup: Cognos Analytics \ view thread
I thought in order to put a report into a dashboard you had to have HTTPS enabled? Then it was as simple as what Norbert says. ------------------------------ Jeff Jones ------------------------------