List of Contributions

Ethan Davis

Contact Details

My Content

1 to 10 of 10 total
Posted By Ethan Davis Jun 10, 2021 10:09 AM
Found In Egroup: Cognos Analytics
\ view thread
We recently moved from 11.0.11 to 11.1.7. We have a report which only uses database tables, and only data modules (not framework manager). We have an issue when all 3 pages of the report are included. If we update the report to only have page 1 OR just pages 2,3 then it runs (quite a bit slower than ...
Posted By Ethan Davis Jun 10, 2021 10:09 AM
Found In Library: Cognos Analytics
Posted By Ethan Davis May 5, 2021 4:33 PM
Found In Egroup: Cognos Analytics
\ view thread
We have moved from 11.0.11 to 11.1.7 and are having trouble with one report we migrated over. It never completes when we run it. We have let it run for up to 30 minutes. In 11.0.11 it ran in about 3.5 minutes. I made a copy and chopped a lot out of it until it would run and complete. It contains a ...
Posted By Ethan Davis Apr 23, 2021 12:51 PM
Found In Egroup: Cognos Analytics
\ view thread
I have a similar situation with the same error. We are using data modules and not framework manager. The report runs fine in version 11.0.11. We are rolling out version 11.1.7 and that is where it is giving the error. I agree, that the real solution is to find a way to not use the cross join. However, ...
Posted By Ethan Davis Apr 15, 2021 12:52 PM
Found In Egroup: Cognos Analytics
\ view thread
Thank you Ralf. When I update 'Last Modified Substring' to substring([Lastmdt],1,7) then I no longer get the error. However, my running total is now counting items of all 'revisions' not just where it is 1. The query has a filter for [C].[Site_Performance_DM_Revs_CSP033].[dat_aqu_35676].[revision] ...
Posted By Ethan Davis Apr 14, 2021 1:47 PM
Found In Egroup: Cognos Analytics
\ view thread
We are moving from 11.0.11 to 11.1.7 and have run into an error in one report that we ported over. Through the process of elimination I have narrowed down the issue to an expression that uses running-total. The full expression is: running-total(count(distinct([C].[Site_Performance_DM_Revs_CSP033 ...
Posted By Ethan Davis Feb 18, 2021 9:45 AM
Found In Egroup: Cognos Analytics
\ view thread
We are in the middle of testing exporting / importing the Content Store to the latest version of Cognos i.e. 11.0.11 to 11.1.7 Interim Fix 3 In a brand new Content Store while doing the import we select the following options: Upgrade all report specifications to the latest version ...
Posted By Ethan Davis Mar 2, 2020 11:56 AM
Found In Egroup: Cognos Analytics
\ view thread
Within a List (sites and subjects), I have added a sub Total summary on one column. This column is a calculated field that returns a 1 or 0. Without the Total on the column, the values returned are correct. However, after adding the Total, some values returned for some subjects, change from a 1 to ...
Posted By Ethan Davis Feb 28, 2020 12:50 PM
Found In Egroup: Cognos Analytics
\ view thread
In a List, we use the built-in functionality for 'filter' > 'Create Custom Filter'. When we run the report from the Cognos designer, the filter works as expected. I.e. it shows all the unique values for the column we selected to filter on. However, we have Cognos integrated into our platform. ...