List of Contributions

Jim Denton

Contact Details

My Content

1 to 10 of 10 total
Posted By Jim Denton Jun 10, 2021 12:28 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, I made a copy of a Cognos report page, and created a new query and pointed to it, but it still remains synchronized to the other page. I have created a second query (a copy of the first one also), and pointed to it. Unfortunately I made a lot of changes to the second page which also overwrote ...
Posted By Jim Denton Apr 16, 2021 6:35 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, I know there is a concat function to join 2 strings, but is there a way to concatenate a larger number of pieces involving complex strings made from complex math functions: e.g. Concat (string(complex math stuff 1)) separated by a left parenthesis followed by string(complex math stuff 2) ...
Posted By Jim Denton Apr 10, 2021 4:39 PM
Found In Egroup: Cognos Analytics
\ view thread
Thanks for all of the help. I was able to use the _month function BUT ... for some reason one of reports generates an error "The vendor specific function "_month" is not supported." Same code copied doesn't work. I tried without the underscore and got the same message. Jim ------------------------------ ...
Posted By Jim Denton Apr 9, 2021 5:02 PM
Found In Egroup: Cognos Analytics
\ view thread
Something like that. Where can I find documentation on Cognos data item expressions? I need to find out for example if there is a Month function, to get the month of a date, and IN funcition, to get at the date check Visit_Date IN Month(Date). Or perhaps cleaner would be Month(Visit_Date) = Month(Month_Column). ...
Posted By Jim Denton Apr 9, 2021 3:46 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, Need help with writing a data item expression - hopefully can write a query: Count the number of Visit dates in Month where the Assessment is value X. Currently I have a counting function to get X based on the user entering a start and end date range for Visit, but now I need it to be based ...
Posted By Jim Denton Mar 16, 2021 11:35 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, I am trying to sum a numerical column but I get error "TypeError: Cannot read property 'getAttribute' of null at Object._PUK._ZG2 (https://smartreportsv2.eclinicalos.com/bi/pat/rsstartupblock_6.js:15:30368) and then additional "at Object ..". The column data is numerical, though perhaps I ...
Posted By Jim Denton Feb 14, 2021 1:25 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, When I hit the Sigma summarize option and choose Total like I usually do, I get error "TypeError: Cannot read property 'getAttribute' of null at Object._PUK._ZG2 (https://smartreportsv2.eclinicalos.com/bi/pat/rsstartupblock_6.js:15:30368) ..." and then additional "...at Object ..." listings. ...
Posted By Jim Denton Feb 11, 2021 5:36 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, I want to join 2 tables that have no common/unique indexes. They do both have the field/column "site number", but they both have multiple of the same site numbers. Do I perhaps need to create a 3rd table with just the "site number" with unique site numbers and do a 1-to-many to both of ...
Posted By Jim Denton Feb 5, 2021 6:25 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, Is there a way to display only the summary rows in a list? Or perhaps I need to build the report in a different way, with somehow pulling the summary information from an intermediate list. Jim ------------------------------ Jim Denton ------------------------------
Posted By Jim Denton Feb 5, 2021 6:25 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, This is my first post and I just started using Cognos this week. I am working toward creating some KPI reports for a client, and came across a challenge I haven't figured out. I have a list with summary counts, and I want ONLY the summary rows, not the data rows, for a brief summary chart. ...