List of Contributions

Chris Turner

Contact Details

My Content

1 to 20 of 50+ total

RE: Can you have different delimiters for specific reports

Posted By Chris Turner Thu April 04, 2024 12:00 PM
Found In Egroup: Cognos Analytics \ view thread
To the best of my knowledge, that's a system-wide setting...you can't change it for a subset of reports. ------------------------------ Chris Turner ------------------------------

RE: Can you have different delimiters for specific reports

Posted By Chris Turner Thu April 04, 2024 10:44 AM
Found In Egroup: Cognos Analytics \ view thread
Is this for sending the results out to csv or something similar? ------------------------------ Chris Turner ------------------------------

RE: unable to obtain information on direct reports

Posted By Chris Turner Mon March 04, 2024 02:55 AM
Found In Egroup: IBM Business Analytics \ view thread
This "team" is a bunch of individuals, located around the globe, that provide ad hoc help to people on general topics and issues. The problem that you're having is specific to you, and one that you need to take up with the technical team within your company / business etc. You will need to find out from ...

RE: Report as datasource

Posted By Chris Turner Fri February 23, 2024 04:48 AM
Found In Egroup: Cognos Analytics \ view thread
Another option would be to bring those fields and calculations into a data module ------------------------------ Chris Turner ------------------------------

RE: Set Yesterday as default date for Date Prompt to enable scheduled reports

Posted By Chris Turner Mon February 19, 2024 07:17 AM
Found In Egroup: Cognos Analytics \ view thread
I wrote this blog post a lifetime ago, but I think it will still do the job for you. When you schedule the report you just need to select Yesterday http://cognostips.weebly.com/blog/date-prompts Sent from Outlook for iOS

RE: unable to obtain information on direct reports

Posted By Chris Turner Wed February 14, 2024 03:00 AM
Found In Egroup: IBM Business Analytics \ view thread
What changed between when you could access the folder, and when you couldn't? ------------------------------ Chris Turner ------------------------------

RE: Showing additional info in summary for Excel export

Posted By Chris Turner Thu February 08, 2024 03:12 AM
Found In Egroup: IBM Business Analytics \ view thread
In your report you probably just need something along the lines of: [Position], [Employee No], total([Hours Worked], total(Salary]) ------------------------------ Chris Turner ------------------------------

RE: How to add dynamic conditional footer in cognos report

Posted By Chris Turner Thu November 02, 2023 05:27 AM
Found In Egroup: Cognos Analytics \ view thread
Put a conditional block in the footer for that page perhaps? ------------------------------ Chris Turner ------------------------------

RE: XQE-V5-0017 V5 syntax error

Posted By Chris Turner Fri October 20, 2023 03:56 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Milind, That's likely to be a combination of your data, and the way that CASE statements work. When a case statement gets to a branch that evaluates to true, it executes that branch then exits the statement. I don't know what your data is like, or how you want to evalute it, but you might ...

RE: XQE-V5-0017 V5 syntax error

Posted By Chris Turner Mon October 16, 2023 06:29 AM
Found In Egroup: Cognos Analytics \ view thread
I think your CASE statement should be something like this: case when [FNMP-DW-DS].[Virtual Machine].[Located in Service Provider Datacenter]=0 then 'On-premises' when [FNMP-DW-DS].[Virtual Machine].[Located in Service Provider Datacenter] <>0 then 'Cloud' when [FNMP-DW-DS].[Comput ...

RE: Dynamic Date Filters

Posted By Chris Turner Wed June 28, 2023 03:09 AM
Found In Egroup: IBM Business Analytics \ view thread
Does your [Facilty - Created Timestamp] field have a time element to it? If it does then you probably need to cast it first, e.g. (?p_ReportDate? = 'Today' and cast([Receipt].[Facility - Created Timestamp],date) = current_date ) OR (?p_ReportDate? = 'Previous Day' and cast([Receipt].[Facility ...

RE: Dynamic Display Different Measures on Line Chart

Posted By Chris Turner Wed June 21, 2023 03:08 AM
Found In Egroup: Cognos Analytics \ view thread
My approach would be a bit long-winded, and I definitely wouldn't want to do it for more than, say, four measures. I'd create a chart for each combination, then control which one gets displayed using render variables. In your case I think you'd need 15 charts and the corresponding 15 render variables. ...

RE: Join with many records e return exception

Posted By Chris Turner Tue June 06, 2023 05:35 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Gustavo - I don't know if it's the most performant way of doing it, but I'd create a left outer join from dataset B to dataset A on Client ID = Participant ID, then filter for Participant ID is missing ------------------------------ Chris Turner ------------------------------

RE: failed login

Posted By Chris Turner Fri May 26, 2023 02:56 AM
Found In Egroup: IBM Business Analytics \ view thread
Presumably these reports worked before? If so, what's changed since? The error you've inlcuded appears to be related to the database - has it moved, has the security changed, has someone altered the connection in Cognos? ------------------------------ Chris Turner ---------------------------- ...

RE: Grey Out/Disable Certain Date in Date Prompt

Posted By Chris Turner Mon May 15, 2023 10:50 AM
Found In Egroup: Cognos Analytics \ view thread
Not that I know of if you want to have a date / calendar type prompt for the dates. You can achieve it by creating a value prompt, and a query from your data module to provide the values... ------------------------------ Chris Turner ------------------------------

RE: Cognos Output removing leading zeros in CSV format

Posted By Chris Turner Thu April 27, 2023 08:48 AM
Found In Egroup: Cognos Analytics \ view thread
What are you using to view the CSV file? Excel will remove the zeroes by default from memory. If you use something like Notepad does it still display without the leading zeroes? ------------------------------ Chris Turner ------------------------------

RE: Date Format in Table List Header Using Report Expression

Posted By Chris Turner Fri April 14, 2023 07:01 AM
Found In Egroup: Cognos Analytics \ view thread
Depending on what your needs are, I'd be tempted to break that up into separate chunks and just concatenate them. So something along the lines of 'As at' + cast(month(_add_months(ParamValue('data_Filter'),-1)) as char(3)) + cast(year(_add_months(ParamValue('date_filter),-1)) as char(4)) I haven't ...

RE: How to apply maximum function so that the customer name with maximum revenue only shows

Posted By Chris Turner Wed April 12, 2023 03:56 AM
Found In Egroup: Cognos Analytics \ view thread
You probably want a filter with something like [Revenue] = max([Revenue] for report) ------------------------------ Chris Turner ------------------------------

RE: Performing operations like finding maximum revenue recorded by a customer

Posted By Chris Turner Tue April 11, 2023 05:22 AM
Found In Egroup: IBM Business Analytics \ view thread
In the screenshot you've posted above, you can see New Report > Pages > Page1 at the top. If you click on New Report it should give you a drop down with Pages, Prompt Pages, Queries etc. If you click on Queries you can create a new query or edit an existing one. Hope that helps. ------------------------------ ...

RE: Mismatched between Cognos and OMS

Posted By Chris Turner Wed March 08, 2023 03:17 AM
Found In Egroup: Cognos Analytics \ view thread
Make sure that the SQL in the same in both of your queries. If it is then the difference is down to the data ------------------------------ Chris Turner ------------------------------