List of Contributions

Ethan Davis

Contact Details

My Content

1 to 11 of 11 total

"FS1" in error message

Posted By Ethan Davis Thu July 01, 2021 12:00 PM
Found In Egroup: Cognos Analytics \ view thread
I am getting the following error message from a report in version 11.1.7. It uses a Data Module; not Framework Manager. XQE-PLN-0248 The column 'Sitenum' of 'FS1' could not be found in the model. Possibly caused by out-of-date query subject definition: 'FS1' 'FS1' seems to refer to a table in the ...

ArrayStoreException

Posted By Ethan Davis Thu June 10, 2021 10:10 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 ...

ArrayStoreException

Posted By Ethan Davis Thu June 10, 2021 10:09 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Moving from 11.0.11 to 11.1.7: joined queries

Posted By Ethan Davis Wed May 05, 2021 04: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 ...

RE: Cross Join Error in Data Module

Posted By Ethan Davis Fri April 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, ...

RE: Running-total causing error after upgrading to 11.1.7

Posted By Ethan Davis Thu April 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] = ...

Running-total causing error after upgrading to 11.1.7

Posted By Ethan Davis Wed April 14, 2021 01:48 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 ...

Report error after upgrade to 11.1.7

Posted By Ethan Davis Thu February 18, 2021 09: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 Do not assign ...

Adding a 'Total' on a column in a List affects the data in the column

Posted By Ethan Davis Mon March 02, 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 a ...

Adding a 'Total' on a column in a List affects the data in the column

Posted By Ethan Davis Mon March 02, 2020 11:55 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

'Create Custom Filter' query is different depending on where report is run

Posted By Ethan Davis Fri February 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. From ...