List of Contributions

John Mares

Contact Details

My Content

1 to 12 of 12 total

RE: Not able to Drag over or click into

Posted By John Mares Thu October 22, 2020 01:03 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks, check myself Chrome is working again edge is still out though ------------------------------ John Mares ------------------------------

Not able to Drag over or click into

Posted By John Mares Tue October 20, 2020 10:30 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Not able to Drag over or click into

Posted By John Mares Tue October 20, 2020 10:30 AM
Found In Egroup: Cognos Analytics \ view thread
I now have to click on the blue bar icon or the magnifying glass in order to drag over into my project or search that data item Cognos when using Cognos in Chrome or Edge. If I use internet explorer it still works like it use too I can still drag over by click on the name text or open search by clicking ...

RE: Context Filter

Posted By John Mares Tue April 07, 2020 10:52 AM
Found In Egroup: Cognos Analytics \ view thread
I believe so (little unclear on what dimension means- new at this and self taught on a client portal version ) They are from different hierarchies as I cannot drop them into the context filter at the same time which is one way of making the context filter do an "or filter" I do not get an error message ...

Context Filter

Posted By John Mares Mon April 06, 2020 12:58 PM
Found In Egroup: Cognos Analytics \ view thread
Can I set it up so I can run an or in the context filter with members from different hierarchy? Please note I am working with a client-facing portal so a lot of advanced options are limited. I want it to show claimants that have a claim in the disease > Cancer or have a claim in the Major Diagnostic ...

RE: issue with cast and scientific notation

Posted By John Mares Fri August 30, 2019 03:58 PM
Found In Egroup: Cognos Analytics \ view thread
​Thanks 'Single Count is '||(cast ( cast( [numbercheck2], decimal(10,0)) , varchar(15)))||'% of enrollment' worked with [numbercheck2] = (([Medical].[Project].[Number of Single]/[Medical].[Project].[Number of Lives])*100) however if I try to build it all as one data item 'Single Count is '||(cast ...

RE: issue with cast and scientific notation

Posted By John Mares Mon August 26, 2019 09:37 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks that did the trick. ------------------------------ John Mares ------------------------------

issue with cast and scientific notation

Posted By John Mares Fri August 23, 2019 06:17 PM
Found In Egroup: Cognos Analytics \ view thread
​I am trying to shift a Intersect(Tuple) type that I believe is integer to string cast ([Paid,Employee], varchar(15)) works but it puts the number into scientific notation even when it small such as 300 (data comes in fine if I don't shift the data type but I need to include the numbers in string ...

RE: Doing my first deep dive into Cognos Analytics and looking how to do calculations

Posted By John Mares Fri August 23, 2019 05:54 PM
Found In Egroup: Cognos Analytics \ view thread
Good Afternoon That does not seem to work either but I believe I found a work around using intersections. Thank you for your help. ------------------------------ John Mares ------------------------------

RE: Doing my first deep dive into Cognos Analytics and looking how to do calculations

Posted By John Mares Tue August 20, 2019 03:44 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks it looks a lot better but it is still not working. The expression I am trying that throw the least errors is ​case when [Medical].[Gender].[Gender].[Gender]= [Female] then [Medical].[Measures].[Paid] end. The error I get is RSV-VAL-0010 Failed to load the report specifications XQE-PLN-0153. Found ...

Doing my first deep dive into Cognos Analytics and looking how to do calculations

Posted By John Mares Thu August 08, 2019 09:23 AM
Found In Egroup: Cognos Analytics \ view thread
​This is my first time doing a deep dive into Cognos I got a data set of medical records. I can drop in a filter for gender or put it in the right side of a table to see the paid amount for females but I am not sure how I build a Query calculation to auto show this My best guess would be Create calculation ...

Doing my first deep dive into Cognos Analytics and looking how to do calculations

Posted By John Mares Wed August 07, 2019 04:28 PM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson