List of Contributions

Kiran Passumarthi

Contact Details

My Content

1 to 20 of 50+ total

RE: IBM Cognos Administration - Schedules

Posted By Kiran Passumarthi Mon March 04, 2024 01:05 AM
Found In Egroup: Cognos Analytics \ view thread
HI Dagur, You can select all the required activities from Upcoming Activities section of the Status tab in Administration Console and then click on Suspend icon at the top right of that screen. You will then be prompted to pick a date and time till when those activities need to be suspended. ...

RE: Indian fonts in reports and dashboards

Posted By Kiran Passumarthi Fri October 06, 2023 11:00 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Patrick, Thanks for the response. We tried different browsers but all cognos environments we tried are on windows only; we do not have linux installations. We did open a ticket with IBM support but I want to check with community members in parallel as we are not making much progress there. ...

Indian fonts in reports and dashboards

Posted By Kiran Passumarthi Fri October 06, 2023 02:00 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, We have a multilingual application where users enter data in different languages, and we want to show whatever they entered in cognos outputs. We don't see any problem with European languages by default (i.e. without setting any specific font) but when it comes to Indian languages only boxes ...

RE: Formatting Email body with images

Posted By Kiran Passumarthi Mon June 12, 2023 08:58 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mack, You can select both outputs in the schedule. HTML will be embedded in the mail body and excel will be send as an attachment. If the content should be different in excel and the mail body, then you can use ReportOutput() function and apply conditional style in the report so that whatever ...

RE: Formatting Email body with images

Posted By Kiran Passumarthi Mon June 12, 2023 02:33 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mack, If your scheduled output is HTML, the content of the report is embedded into the mail body. So, you can include your logo in the report and schedule the output in html format. Regards, Kiran ------------------------------ Kiran Passumarthi www.linkedin.com/in/kiranpassumarthi ...

RE: XML Data File

Posted By Kiran Passumarthi Tue May 09, 2023 07:01 AM
Found In Egroup: Cognos Analytics \ view thread
See if this helps - https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=types-xml-data-sources Regards, ------------------------------ Kiran Passumarthi www.linkedin.com/in/kiranpassumarthi ------------------------------

RE: Difference between Template and Theme

Posted By Kiran Passumarthi Mon May 01, 2023 02:31 AM
Found In Egroup: Cognos Analytics \ view thread
Hey Paul, It is interesting that you used Indian state names in your explanation and made it a more personalized response, hats off to your effort :) Regards, ------------------------------ Kiran Passumarthi www.linkedin.com/in/kiranpassumarthi ------------------------------

Reg. CA 11.2.4 Sql server support

Posted By Kiran Passumarthi Tue April 18, 2023 10:09 AM
Found In Egroup: Cognos Analytics \ view thread
Hi there, Does anyone know if CA 11.2.4 supports MS SQL Server 2022 Enterprise Edition? The Supported Environments page attached doesn't clearly specify as there are two sets for MS SQL Server. ------------------------------ Kiran Passumarthi www.linkedin.com/in/kiranpassumarthi ---- ...

RE: Remove Column Header in Cognos Report When Export to CSV

Posted By Kiran Passumarthi Mon April 03, 2023 03:00 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mohamad, I misread it to be the report header and not the list header. Looks like depending on the version you are using, even the second option may or may not work; I am on 11.1.7 and second option doesn't work for me and csv always displays the column titles. I found this technote. ...

RE: Remove Column Header in Cognos Report When Export to CSV

Posted By Kiran Passumarthi Mon April 03, 2023 01:21 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mohamad, There are two ways to do this. 1) If you want to hide the header in some formats but want to display in some other formats, then you can use render variables and reportOutput() function to achieve this. 2) If you want to hide it in all exported formats, then set the style of the ...

RE: Drill thru -

Posted By Kiran Passumarthi Thu March 30, 2023 01:34 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mary, Select any value for each of those All Tabs or This Tab filters for them to appear in the drill thru definition. Regards ------------------------------ Kiran Passumarthi www.linkedin.com/in/kiranpassumarthi ------------------------------

RE: Can we set the id property to the html elements in the report

Posted By Kiran Passumarthi Fri February 10, 2023 05:25 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Karthik, Using HTML items and setting the IDs for the encircling objects is one way but I do not know if your RPA tool needs to find the exact object's ID for automation. Most RPA tools accept xpath as an alternative, you can look into that. Regards, ------------------------------ ...

RE: Schedules in Cognos fail throwing error

Posted By Kiran Passumarthi Fri February 10, 2023 05:15 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mack, If you are seeing 'unknown' for Scheduled By it means that user is no more available in the security namespace. So, reassigning the schedule to a different owner will let it to run successfully. Regards, ------------------------------ Kiran Passumarthi www.linkedin. ...

RE: Cognos for Microsoft Office - Prompting for User and Password intermittently

Posted By Kiran Passumarthi Mon December 19, 2022 01:32 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Andrew, Not sure if this would help, but check the Options in IBM tab of Excel once you connect to the Cognos environment. There is an Authentication section for forms authentication; toggle and see if that helps. Also, though I am unable to recall, unchecking 'Show Information Cards' option helped ...

RE: DATA MODULE and CQM

Posted By Kiran Passumarthi Wed December 07, 2022 03:20 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Daniel, Initially when DMs were introduced in 11.0 stream, they were supporting only DQM packages. But later on, the support for CQM was also added but I think they have to conform to the modelling guidelines. Documentation might not have been updated but I will let someone from IBM comment. ...

RE: RaaS - report as a service

Posted By Kiran Passumarthi Wed November 30, 2022 03:37 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Moises, Unfortunately, no. We have the same requirement as some of our customers wanted to use Cognos report data in power BI using api data source. We are creating a REST API using SDK that a) authenticates the user using the credentials passed to the API call b) takes the saved report output ...

RE: Cognos 11.2.2 - List View as default view for users

Posted By Kiran Passumarthi Wed November 09, 2022 02:55 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Jiri, Understood, we will be in the same boat when we upgrade to 11.2 stream next year. I do not know yet if an extension can help, but I think it is an option to try. We can probably simulate a click action on the list view icon via javascript on screen load. Regards, ------------------------------ ...

RE: Cognos 11.2.2 - List View as default view for users

Posted By Kiran Passumarthi Wed November 09, 2022 01:33 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Jiri, I asked this question in one of the Ask Me Anything sessions and @RACHEL SU mentioned that the AI feature of Cognos Analytics will take care of that i.e. if the user navigates to list view for the first few times, then for all future logins, the user will be directed to list view itself. ...

RE: Cognos scheduled email sending

Posted By Kiran Passumarthi Wed November 09, 2022 01:23 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Daniele, You can follow the below technote to clear pending schedules that are in queue. https://www.ibm.com/support/pages/how-use-ncdrop-script-cognos-analytics-11 This works for 10.2 versions as well. Also, if you need to stop any future runs of the schedules as well, then go to Manage ...

RE: Reporting from Multiple Packages

Posted By Kiran Passumarthi Thu September 22, 2022 10:02 AM
Found In Egroup: Cognos Analytics \ view thread
HI Mauro You can add all the required packages to a data module (no relationships needed) and use the data module for your report. You will then be able to create each query from different package and join / union them in report. Hope that helps. Regards ------------------------------ ...