List of Contributions

Dave Chirayath

Contact Details

My Content

1 to 20 of 27 total
Posted By Dave Chirayath Nov 9, 2020 8:08 AM
Found In Egroup: Cognos Analytics
\ view thread
Here the IBM documentation on what can be used: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/c_ca_mdlg_sql.html ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Nov 5, 2020 7:45 AM
Found In Egroup: IBM Business Analytics
\ view thread
Thanks for this info Logan! ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Nov 2, 2020 10:03 AM
Found In Egroup: IBM Business Analytics
\ view thread
Hi everyone, I am researching some questions a colleague has about building dashboards in CA 11.1.4 and have a few I can't find definitive answers for so I was hoping I could get some answers here. Is the best place for calculations within the data module? I so far haven't seen any way to create ...
Posted By Dave Chirayath Oct 28, 2020 9:02 AM
Found In Egroup: IBM Business Analytics
\ view thread
Thanks for your help with this Logan - much appreciated! ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Oct 27, 2020 10:00 AM
Found In Egroup: IBM Business Analytics
\ view thread
Thanks, Logan. Unfortunately, the behavior that is described is not what I'm seeing. If I look at the data in FM, it does not have the time component, but in Cognos it does. See the attached pic. ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Oct 26, 2020 12:27 PM
Found In Egroup: IBM Business Analytics
\ view thread
I'm adding a new Query Item in Framework Manager. I am working in CA 11.1.4. I want this field to be only the date portion of a date-time database field. The field expression is cast([Audit].[COGIPF_USERLOGON].[TIME STAMP], date) When I test the data it appears that the field is only returning ...
Posted By Dave Chirayath Oct 16, 2020 5:08 PM
Found In Egroup: IBM Business Analytics
\ view thread
I am working on a dashboard in 11.1.4 and have a date field that I cannot group. The date field in question is an attribute and I have multiple data items associated with each date, so I want to group the dates and display a count of the data items on that date. What should I be doing to group the ...
Posted By Dave Chirayath Sep 14, 2020 9:50 AM
Found In Egroup: Cognos Analytics
\ view thread
What version of Cognos are you using with Magic? ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Sep 14, 2020 8:11 AM
Found In Egroup: Cognos Analytics
\ view thread
I want the sorting you describe for easier navigation for my users who are building out data modules. I am not seeing the buttons you describe. Is magic an extension? I am not seeing it listed in the Accelerator Catalog. ------------------------------ Dave Chirayath ----------------------------- ...
Posted By Dave Chirayath Sep 11, 2020 2:39 PM
Found In Egroup: IBM Business Analytics
\ view thread
Thanks Nick! ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Sep 11, 2020 11:48 AM
Found In Egroup: IBM Business Analytics
\ view thread
Nick - nothing comes up with that link. ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Sep 10, 2020 10:04 AM
Found In Egroup: Cognos Analytics
\ view thread
Thanks, Ian - I'll try out the folders you mentioned. ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Sep 10, 2020 9:30 AM
Found In Egroup: Cognos Analytics
\ view thread
I am on 11.1.4. So you have to manually order the items in the data module then? I was looking for a way to sort everything within the data module that wasn't so time-consuming. ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Sep 10, 2020 9:05 AM
Found In Egroup: Cognos Analytics
\ view thread
Is it possible to sort data items in a data module? I am not seeing a way to do that and my users have to browse through long lists of data to find what they need. I've attached a pic of what the GOSALESHR data module looks like. I want to sort the items under Employee alphabetically. ---------- ...
Posted By Dave Chirayath Sep 10, 2020 9:04 AM
Found In Library: Cognos Analytics
Posted By Dave Chirayath Aug 20, 2020 7:15 AM
Found In Egroup: IBM Business Analytics
\ view thread
Thanks Torben! ------------------------------ Dave Chirayath ------------------------------
Posted By Dave Chirayath Jul 24, 2020 10:51 AM
Found In Egroup: IBM Business Analytics
\ view thread
I am creating a report in 11.1.4 from a data module I created and am having trouble with the joins when running the report. When I created the data module in Analytics, I specified the join conditions for the tables I used, but when I run the report it is pulling back all the data from the three tables ...
Posted By Dave Chirayath Jul 16, 2020 9:05 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Pradeep, What version of Cognos are you using? I found the following link on the IBM site pertaining to the issues you mentioned for versions 11.1 and up: https://www.ibm.com/support/pages/how-do-you-restrict-users-based-their-license-roles-cognos-analytics-version-1111 I hope that helps. ...
Posted By Dave Chirayath Jul 2, 2020 8:26 AM
Found In Egroup: IBM Business Analytics
\ view thread
Hi Jerome, I have also looked for a more clear and concise list of what data to use and how for various visualizations and not found anything outside of this tutorial from IBM: https://www.ibm.com/cloud/garage/dte/tutorial/ibm-cognos-analytics-1114-getting-started-dashboards . I took that tutorial ...