List of Contributions

Sanjay Chakravarty

Contact Details

My Content

1 to 20 of 44 total

RE: Last Month (Filter)

Posted By Sanjay Chakravarty Tue May 04, 2021 11:30 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Jackey I think you will need to use first of month and last of month, replace the sysdate with current_date. See below expression [source].[datecolumn] between_first_of_month(_add_months(sysdate(),-1)) and _last_of_month(_add_months(sysdate(),-1)) Thanks Sanjay ------------------------------ ...

RE: Javascript to set default values in date prompts

Posted By Sanjay Chakravarty Sat April 03, 2021 06:11 PM
Found In Egroup: Cognos Analytics \ view thread
Hi Kiran Have you checked the Sample Report from CA. If you have not i suggest you start there. There is Date Prompt Preset Report which uses custom control using JS. Thanks Sanjay ------------------------------ Sanjay Chakravarty ------------------------------

RE: Oracle Invalid Relational Operator When Using NOT in Filter of Report

Posted By Sanjay Chakravarty Tue March 23, 2021 07:59 PM
Found In Egroup: Cognos Analytics \ view thread
Hi NOT IN is a valid relational operator , I don't think you can use NOT as is.Also you are missing one closing parenthesis. Can you send the full expression if possible Thank you ------------------------------ Sanjay Chakravarty ------------------------------

RE: CA 11.1.7 FP2 Upgrade with SSL from CA 11.0.13 - Failure to Restart Services

Posted By Sanjay Chakravarty Fri March 19, 2021 12:42 PM
Found In Egroup: Cognos Analytics \ view thread
Adam Not sure if you have followed this below article. I have installed Internally Signed & wild card certificates and no issues. https://www.ibm.com/support/pages/how-add-3rd-party-ca-allow-ssl-between-components-ibm-cognos-analytics-11 If you have taken back up of the Configuration, you can always ...

RE: CA 11.1.7 FP2 Upgrade with SSL from CA 11.0.13 - Failure to Restart Services

Posted By Sanjay Chakravarty Thu March 18, 2021 09:27 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Adam Seems like it is a issue with certificates. What is your SHA Algorithm. Also have you verified with iKeyman that the certs are properly installed. Also may be try changing the Standard Conformance to IBM Cognos from NIST SP 800-131 A although NIST is preferred and more secure. Does HTTP works ...

RE: Problem with Cognos standard roles

Posted By Sanjay Chakravarty Mon February 08, 2021 11:26 PM
Found In Egroup: Cognos Analytics \ view thread
Have you disabled the Everyone group? ------------------------------ Sanjay Chakravarty ------------------------------

Wild Card Certificates &CA signed Certificate

Posted By Sanjay Chakravarty Fri January 15, 2021 08:48 AM
Found In Egroup: Cognos Analytics \ view thread
Hello Greetings Has any used wild card certificates in CA 11.1.7 WIN 2019 for SSL. This is with Dispatcher/CM only. Also has anyone tried using Third Party CA signed wher the CN=DNS instead of FQDN of the server and DNS C-Names listed for alias. Any help is highly appreciated Thank you ------ ...

RE: User Cannot run a Report

Posted By Sanjay Chakravarty Tue November 17, 2020 05:06 PM
Found In Egroup: Cognos Analytics \ view thread
Hello Rick What error is she getting? Did you saved in a folder that does not have permisison Thank you Sanjay ------------------------------ Sanjay Chakravarty ------------------------------

RE: Unable to Launch Cognos Authoring in Chrome v85

Posted By Sanjay Chakravarty Mon September 21, 2020 09:17 PM
Found In Egroup: Cognos Analytics \ view thread
Do you have multiple Server, if so order of starting/stopping may cause issue. Make sure that the primary Content Manager server is running before any other servers are brought online. ------------------------------ Sanjay Chakravarty ------------------------------

SAML 2.0 on Azure AD with CA 11.1.7

Posted By Sanjay Chakravarty Fri September 11, 2020 11:36 AM
Found In Egroup: IBM Business Analytics \ view thread
Hello All Good Morning. Hope you guys are doing well. I was wondering if someone has implemeted SAML 2.0 on Azure AD with CA 11.1.7 Does Cognos 11.x authentication supports using SAML 2.0 on Azure AD? I did some digging and it appears to me Cognos supports OpenID/OAuth, but not SAML in any straightforward ...

RE: Cognos Audit Extension Not Working after Upgrading to CA 11.1.7

Posted By Sanjay Chakravarty Tue September 01, 2020 03:37 PM
Found In Egroup: Cognos Analytics \ view thread
It is under Resource to the right of the page click on the drop down icon there is a zip file ------------------------------ Sanjay Chakravarty ------------------------------

RE: Rename Hyperlink to User friendly Form

Posted By Sanjay Chakravarty Wed August 19, 2020 12:46 PM
Found In Egroup: Cognos Analytics \ view thread
Have you tried using html tags in the body of the email. Something like this below insted of using out of the box include link option Report Name Thank you Sanjay ------------------------------ Sanjay Chakravarty ------------------------------

RE: IBM Cognos Configuration did not receive a response

Posted By Sanjay Chakravarty Thu July 16, 2020 10:48 PM
Found In Egroup: Cognos Analytics \ view thread
I am assuming you have not set any JAVA_HOME other than Cognos IBM JAVA. If you have to remove the java from ENV variables, did you restart the server not Service ------------------------------ Sanjay Chakravarty ------------------------------

RE: What's New banner

Posted By Sanjay Chakravarty Mon June 22, 2020 10:19 AM
Found In Egroup: Cognos Analytics \ view thread
Here is the link to completely remove it https://www.ibm.com/support/pages/how-remove-whats-new-banner-cognos-1115-home-page If you want to hide it you can play with Consumers Properties>Customization Thank you ------------------------------ Sanjay Chakravarty ------------------------------

RE: Exact source for dashboard visualization

Posted By Sanjay Chakravarty Fri June 19, 2020 12:46 PM
Found In Egroup: Cognos Analytics \ view thread
I think it is little tricky, had to use the control couple of times on chrome, it is kinda hidden as a flybar Thank you ------------------------------ Sanjay Chakravarty ------------------------------

RE: Exact source for dashboard visualization

Posted By Sanjay Chakravarty Fri June 19, 2020 12:13 PM
Found In Egroup: Cognos Analytics \ view thread
Works for me too ------------------------------ Sanjay Chakravarty ------------------------------

RE: answer correction

Posted By Sanjay Chakravarty Wed June 17, 2020 11:22 AM
Found In Egroup: Cognos Analytics \ view thread
C is incorrect because when you create a new Namespace from the configuration you will see Under Type(Group) LDAP Names space provider is present that means it is supported out of the box by Cognos. Regarding your other Q Answer is B .To contain pre-defined and user-defined groups and roles --- ...

RE: answer correction

Posted By Sanjay Chakravarty Wed June 17, 2020 08:53 AM
Found In Egroup: Cognos Analytics \ view thread
Answer is B ------------------------------ Sanjay Chakravarty ------------------------------

RE: Need help to connect to local access database

Posted By Sanjay Chakravarty Thu June 11, 2020 01:09 PM
Found In Egroup: Cognos Analytics \ view thread
Hello Camilo You will need to create a ODBC connection. See below link https://www.ibm.com/support/pages/how-setup-datasource-connection-microsoft-access-database-cognos-analytics Thank you ------------------------------ Sanjay Chakravarty ------------------------------

RE: How to display column headers vertically in HTML report

Posted By Sanjay Chakravarty Thu June 11, 2020 10:02 AM
Found In Egroup: Cognos Analytics \ view thread
Try using a different the browser or deleting the cache ------------------------------ Sanjay Chakravarty ------------------------------