List of Contributions

Sanish John

Contact Details

My Content

1 to 20 of 49 total

Cognos Audit

Posted By Sanish John Tue July 18, 2023 04:17 PM
Found In Egroup: Cognos Analytics \ view thread
Hello - We are looking to build out a summarized version of Cognos Audit and wanted to check with folks to see if anyone has attempted to do something similar. If you are willing to share Tips or if you are willing to share code that would be highly appreciated. Thank you ...

RE: Incremental Upload to Dataset

Posted By Sanish John Tue May 23, 2023 08:58 AM
Found In Egroup: Cognos Analytics \ view thread
Voted. Not sure if you noticed, but it does have a Status: Not under consideration This would be a really useful feature to have for sure. I believe both PowerBI and Tableau have had this in their products for years now. ------------------------------ Sanish John ------------------------- ...

RE: Handling Parameters from Oracle SQL to Cognos

Posted By Sanish John Wed May 03, 2023 08:26 AM
Found In Egroup: Cognos Analytics \ view thread
If this is in Framework Manager, you could try something like this: SELECT I.COMPANY, I.VENDOR, I.IDTE AS "IDATE", I.PDATE AS "PDATE", I.DDATE AS "DDATE" FROM TABLE I LEFT JOIN TABLE2 P ON I.COM = P.COM AND I.VENDOR = P.VENDOR AND P.DATE #SQ(PROMPT('vAsOfDate', 'date'))# ...

Adding Trusted or Endorsement badge to Data Modules (Please vote if you agree)

Posted By Sanish John Thu May 12, 2022 09:00 AM
Found In Egroup: Cognos Analytics \ view thread
Hello Fellow Cognosite - We have submitted an idea and wanted to post it here for visibility. Please lent your support by 'voting' on it if you agree. Copy/pasting it below here also: We would like to have the ability for Central IT Teams to share 'Trusted or Endorsed' Data Modules (maybe ...

RE: Ask Me Anything: Cognos Analytics with Watson - December Edition

Posted By Sanish John Mon December 06, 2021 11:04 AM
Found In Egroup: Cognos Analytics \ view thread
Can we get a rough timeline of when CA 11.2x LTS version will come out? ------------------------------ Sanish John ------------------------------

RE: Data Module Limitations / Best Practices

Posted By Sanish John Thu September 30, 2021 08:59 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Ian, Great insights! I can wait to read your full document. ------------------------------ Sanish John ------------------------------

RE: Portlets Support & Future Plans

Posted By Sanish John Wed February 03, 2021 08:58 AM
Found In Egroup: Cognos Analytics \ view thread
Hello, This did come up in the AMA session that has hosted by IBM yesterday (February 2nd) by Rachel Su. Here is the link to it: https://ibm.webcasts.com/starthere.jsp?ei=1416584&tp_key=65b89717b8. As per IBM, there is no firm date when it is going away (same as Query Studio and Analysis Studio) ...

RE: Securing/Hiding 'Administration console' for Analytics User Licensed role

Posted By Sanish John Wed December 09, 2020 01:04 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks Andy. I did try what you suggested and I do see the same as what you are seeing. IBM's 'by design' is not ideal for what I was looking for. THANK YOU for dedicating the time to walk me thru the options. Much appreciated! Sanish ------------------------------ Sanish John -- ...

RE: Securing/Hiding 'Administration console' for Analytics User Licensed role

Posted By Sanish John Wed December 09, 2020 11:14 AM
Found In Egroup: Cognos Analytics \ view thread
So if I am understanding this correctly, I would need to do the following to get rid of the 'Administration console' (my original question from this thread) is to do the following Remove the Analytics User role into the parent of the main Administration Capability with Access permission Remove ...

RE: Securing/Hiding 'Administration console' for Analytics User Licensed role

Posted By Sanish John Wed December 09, 2020 10:50 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Andy, We do have the Modeller role but it does not have any role/groups within for which my test user belongs to. The way I went about enabling this is as follows: Added the Analytics User role into the parent of the main Administration Capability with Access permission Added the ...

RE: Securing/Hiding 'Administration console' for Analytics User Licensed role

Posted By Sanish John Wed December 09, 2020 10:05 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Andy, Thank you for the excel. That is very helpful and handy to have. Unfortunately, I don't see the Modeller role attached to the Analytics User role. I am not sure if this is the expected behavior. Would be good to get someone from the product team to chime in (@Jason Tavoularis​ maybe?) ...

RE: Securing/Hiding 'Administration console' for Analytics User Licensed role

Posted By Sanish John Tue December 08, 2020 11:19 AM
Found In Egroup: Cognos Analytics \ view thread
I should have mentioned this in my initial post. The version we are trying to do this is on Cognos 11.1.7 FP1 Thanks, ------------------------------ Sanish John ------------------------------

Securing/Hiding 'Administration console' for Analytics User Licensed role

Posted By Sanish John Tue December 08, 2020 10:33 AM
Found In Egroup: Cognos Analytics \ view thread
Hello, I am hoping someone here can guide me on how to securing/Hiding 'Administration console' for Analytics User Licensed role. I am adding a screenshot for context for my question. ------------------------------ Sanish John ------------------------------ #CognosAnalyticswithW ...

RE: Calling all Cognos report authors!

Posted By Sanish John Tue September 01, 2020 10:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Rachel, Thank you for providing the links to the slide deck and recording. You had mentioned that there is a 11.1.7 fix pack coming that may have some additional features that hadn't shipped when 11.1.7 had shipped. Do you have a ETA on when it will be available? Thanks ------------- ...

RE: All the answers you need with Cognos Analytics release 11.1.6

Posted By Sanish John Mon April 20, 2020 11:24 AM
Found In Egroup: Cognos Analytics \ view thread
Hi @Jason Tavoularis, Any updates for us on the release date yet? You had mentioned during your Webinar that it may come out last week. I didn't see any announcements. Thanks, Sanish​ ------------------------------ Sanish John ------------------------------

Customizing the reporting menu in Cognos Analytics Question

Posted By Sanish John Mon April 13, 2020 11:22 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Customizing the reporting menu in Cognos Analytics Question

Posted By Sanish John Mon April 13, 2020 11:22 AM
Found In Egroup: Cognos Analytics \ view thread
Hello, We are on Cognos Analytics 11.1.1 and are planning to start an upgrade project to go to either CA 11.1.5 or CA 11.1.6 end of this month (April 2020). As part of the upgrade process, we want to transition our Query Studio (QS) users into Report Tool. We wanted this transition to be as seamless ...

RE: Integrating IGC with Cognos Analytics Best Practices.

Posted By Sanish John Fri March 27, 2020 09:32 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks @Buddhi Gupta Can you give more details (or point me to where I can find more info)? ​ Thanks ------------------------------ Sanish John ------------------------------

RE: Integrating IGC with Cognos Analytics Best Practices.

Posted By Sanish John Fri March 27, 2020 09:30 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks @Jason Tavoularis. I did see the links above. YouTube does have few videos of the product in action but not for what I am looking for (I am looking for either videos or steps of how its implemented/configured/synced between IGC & Cognos). Thanks ------------------------------ Sanish John ...

Integrating IGC with Cognos Analytics Best Practices.

Posted By Sanish John Mon March 23, 2020 11:37 AM
Found In Egroup: Cognos Analytics \ view thread
Hello, Does anyone have experience integrating IBM InfoSphere Information Governance Catalog (IGC) with Cognos Analytics? If so, could you share your experience and if you have any best practices that you could share? Here is what we have (on-prem) Cognos Analytics 11.1.1 IBM InfoSphere ...