List of Contributions

Chris Turner

Contact Details

My Content

1 to 20 of 44 total

RE: Cognos 11.1.7 UDA-SQL-0023 error connection to database has been terminated due to an unrecoverable

Posted By Chris Turner Jan 13, 2021 7:35 AM
Found In Egroup: Cognos Analytics \ view thread
I don't use Oracle, so I can't be much help I'm afraid. A quick search on that error code yielded these, which might be helpful: https://support.oracle.com/knowledge/Enterprise%20Management/1983860_1.html https://dba.stackexchange.com/questions/238413/oracle-losing-connection-ora-03114-after-some-ti ...

RE: HINT: add comments to your Report QueryItems

Posted By Chris Turner Jan 4, 2021 3:42 AM
Found In Egroup: Cognos Analytics \ view thread
Yep – that's been around for quite a while. I wrote myself a blog post back in the day to remind myself of the format: http://cognostips.weebly.com/blog/comments-in-fields

RE: FIRST_DAY(((CURRENT_DATE) + (-1) YEAR)

Posted By Chris Turner Nov 18, 2020 7:32 AM
Found In Egroup: Cognos Analytics \ view thread
It's not a format I'm used to, but looking at it I'd say it's trying to filter the date in your report from one year ago to today. ------------------------------ Chris Turner ------------------------------

UK Postcode maps

Posted By Chris Turner Oct 31, 2020 7:40 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, This will probably seem very obvious to some of you, but I just don't seem to be able to get my head round it. I've got some sales data at UK Postcode level. I want to display that information on a map at a region level. So, for example, I want to collate all the Manchester postcodes into a region ...

RE: Report Scheduling

Posted By Chris Turner Oct 23, 2020 4:30 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Jerome, Yes, you're correct. The more elegant solution would be to have a trigger that runs on the server and fires on the 1st and the 15th. But without that I can't think of a better way to do it. The report view (A-view) will refer back to the report (A) so any changes that you make there will be ...

RE: Report Scheduling

Posted By Chris Turner Oct 22, 2020 3:46 PM
Found In Egroup: Cognos Analytics \ view thread
Create a report view of the original report. Schedule the report on the 1st and the report view on the 15th. ------------------------------ Chris Turner ------------------------------

RE: Explore Series: Cognos Analytics

Posted By Chris Turner Oct 22, 2020 4:03 AM
Found In Egroup: Cognos Analytics \ view thread
I tried to join, but by the time I got the correct link the event had finished. Do you have the webinar as a recording? ------------------------------ Chris Turner ------------------------------

RE: portale pages as home

Posted By Chris Turner Oct 16, 2020 9:50 AM
Found In Egroup: Cognos Analytics \ view thread
I think you're trying to recreate a portal from the Cognos 8 days...to the best of my knowledge the navigator portals/widgets don't exist anymore. ------------------------------ Chris Turner ------------------------------

RE: Group

Posted By Chris Turner Oct 15, 2020 3:55 PM
Found In Egroup: Cognos Analytics \ view thread
It sort of depends on what you're doing. Assuming you're talking about a report / query then you'd just create a case statement: case when [YourAgeColumn] between 0 and 5 then '0 to 5' when [YourAgeColumn] between 6 and 10 then '6 to 10' ... else 'OMG How Old?' end ------------------------------ ...

RE: Data Module using Stored Procedure

Posted By Chris Turner Jul 7, 2020 11:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Heather - did you get anywhere with this? I'm trying to do the same thing. I've used stored procedures in the past in Framework Manager, but I'm trying to step away from that. ------------------------------ Chris Turner ------------------------------

RE: Special Working Day Calculation

Posted By Chris Turner Jul 3, 2020 3:43 AM
Found In Egroup: Cognos Analytics \ view thread
Wouldn't a running-total make more sense? ------------------------------ Chris Turner ------------------------------

Missing records from export

Posted By Chris Turner Jun 23, 2020 5:50 AM
Found In Egroup: Cognos Analytics \ view thread
I have a report with a couple of queries joined together.In those two queries I can see a specific set of records, which in turn flow into the joined query. The report, which is built over the joined query, shows the records when I view it in HTML. My problem comes when I try to run the report in any ...

Trend lines

Posted By Chris Turner Jun 10, 2020 4:19 AM
Found In Egroup: Cognos Analytics \ view thread
Hi - I want to add a trend line to a chart, but I don't seem to be able to. I've seen this article: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_trendline_new.html#trendline_new But when I try to follow the instructions I don't see anything for trendlines ...

RE: How to calculate week of a month (instead of year)

Posted By Chris Turner Jun 10, 2020 3:02 AM
Found In Egroup: Cognos Analytics \ view thread
Just for the sake of ease of reading, you could alter your statement to be: CASE when (Day of Month]) between 1 and 7 then 1 when (Day of Month]) between 8 and 14 then 2 when (Day of Month]) between 15 and 21 then 3 when (Day of Month]) between 22 and 28 then 4 when (Day of Month]) between ...

RE: Questions

Posted By Chris Turner Jun 1, 2020 10:34 AM
Found In Egroup: Cognos Analytics \ view thread
If we do can we have a share of the raise you're going to get for completing the exam? ------------------------------ Chris Turner ------------------------------

RE: Report Refernce - Can you use 1 report query but not use all the report pages?

Posted By Chris Turner Mar 26, 2020 3:54 AM
Found In Egroup: Cognos Analytics \ view thread
Could you reverse the logic? Have Report 1 reference Report1-Page1, Report1-Page2 etc. Then if you want a report with pages 2 and 4 only, build it and reference those pages. ------------------------------ Chris Turner ------------------------------

Remove -en-gb from exported output

Posted By Chris Turner Mar 11, 2020 5:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hi - apologies if this is a trivial question, or if it's been answered before...I've looked and I can't find an answer. When I run a report and burst it to an external file, the filename has '-en-gb' appended to it. For example, I've specified that the output should be in CSV format and be called despatches. ...

RE: Remove rows from Data Model

Posted By Chris Turner Mar 9, 2020 9:58 AM
Found In Egroup: Cognos Analytics \ view thread
Delete or edit the rows in your original data and re-upload ------------------------------ Chris Turner ------------------------------

RE: Jobs in Classic View only

Posted By Chris Turner Feb 25, 2020 9:24 AM
Found In Egroup: Cognos Analytics \ view thread
I've just got feedback to say that it's a known defect ------------------------------ Chris Turner ------------------------------

RE: Jobs in Classic View only

Posted By Chris Turner Feb 25, 2020 8:00 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Erik - I'm not sure if it's the same thing, but just raised a support case on the IBM site. The ticket number I've got for it is TS003400614 ------------------------------ Chris Turner ------------------------------