List of Contributions

JEAM COELHO

Contact Details

My Content

1 to 20 of 50+ total

RE: Content Store Query to fetch group/role wise reports

Posted By JEAM COELHO Wed November 22, 2023 08:08 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, There is no way to do using SQL in Content Store, because the table field that stores this information is serialized, not plain text. But you can do using Cognos SDK. ------------------------------ JEAM COELHO Cognos Solution Architect LinkedIn: https://www.linkedin.com/in/jeamcoelho/ ...

RE: IBM Cognos 11.0.13 Security Groups on Data module

Posted By JEAM COELHO Fri October 27, 2023 02:14 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, You may achieve this using Cognos macros and filtering data in data modules. Security filter provided by data source connections is not to easy to set for dozens of groups and can be missed if clean and reload metadata of data source. ------------------------------ JEAM COELHO ...

RE: Routing Rules Precedence

Posted By JEAM COELHO Fri October 27, 2023 10:44 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Robert, I appreciate that! Thank you! ------------------------------ JEAM COELHO Cognos Solution Architect LinkedIn: https://www.linkedin.com/in/jeamcoelho/ ------------------------------

RE: Routing Rules Precedence

Posted By JEAM COELHO Fri October 27, 2023 10:27 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Robert, I'm using FQDN too, browser and Cognos Configuration. I have tested with IBM support and they see the same behavior that I'm getting. It's strange that Cognos is differentiating the URL you enter in the browser, it shouldn't do that. Cognos should only go by its own ...

RE: Routing Rules Precedence

Posted By JEAM COELHO Fri October 27, 2023 09:01 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, Robert! In fact, the web server/gateway is not a problem. But as they have their balancing algorithm, they can mask it. Did you run the tests directly accessing the dispatcher URL, without going through the gateway? BTW, I'm in CA 11.2.1 zLinux. ------------------------------ ...

RE: Routing Rules Precedence

Posted By JEAM COELHO Fri October 27, 2023 05:43 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, Robert. I'm sorry, but they don't work. I proved this to IBM support and developers. In my case, as I have 8 servers, I'm using Cognos Gateway with Apache, loading the cognos-load-balance configuration. This can mask the effects of this issue. In the case of the dashboard, Cognos ...

RE: Cognos data sets refresh info

Posted By JEAM COELHO Thu October 26, 2023 02:11 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, Yes, it does in report execution table. But until CA 11.2.2 has a bug that information is not reliable. You should upgrate to 11.2.3 to work fine. ------------------------------ JEAM COELHO Cognos Solution Architect LinkedIn: https://www.linkedin.com/in/jeamcoelho/ ...

RE: Routing Rules Precedence

Posted By JEAM COELHO Thu October 26, 2023 02:09 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, I have only used the routing rules for groups. Using only for user groups, the order on the configuration page is respected top-down. However, there is a problem, routing rules do not work for dashboards. I've already opened a ticket and support responded to me begrudgingly, saying ...

RE: Dashboard Embedded Data Modules - how do you remove them?

Posted By JEAM COELHO Tue October 24, 2023 07:28 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, I have been going through the same thing. When I copy visualizations from one dashto another, I end up with multiple modules. What I have done to solve this is look for the ID of the second module in the dashboard in the specification (hit CTRL + q + /) and modify it to keep the first ...

RE: SDK How to generate a list of schedule reports like the Past Activities tab in Cognos Admin

Posted By JEAM COELHO Mon June 26, 2023 09:09 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, Using this SQL below in Content Store database, you will get all failed schedule. SELECT CMID, OBJECT_TYPE, OWNER, OBJECT_NAME, COUNT(HIST_SEVERITY) ERRORS_COUNT, folder3, folder2, folder1, folder FROM( SELECT s.CMID, UPPER(c.NAME) AS OBJECT_TYPE, UPPER( ...

RE: Datasets - qs.queryExecution.flintServer.sparkThreads

Posted By JEAM COELHO Thu December 15, 2022 08:53 PM
Found In Egroup: Cognos Analytics \ view thread
I got an answer from support Based on the information I found on qs.queryExecution.flintServer.sparkThread Query Service advanced setting, this is an automatically calculated parameter and it should not be changed under normal circumstances. ------------------------------ JEAM COELHO ...

Datasets - qs.queryExecution.flintServer.sparkThreads

Posted By JEAM COELHO Sat December 10, 2022 08:31 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, I'm just looking for some ways to improve performance of queries that touch data sets. I'm curious about one advanced setting of query service: qs.queryExecution.flintServer.sparkThreads https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=reference-query-service-advanced-settings ...

RE: Block Local Query Processing

Posted By JEAM COELHO Mon October 10, 2022 10:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Philipp, Using localtimestamp works without local processing. But this function does not consider my timezone, setting to GMT 00. I'm at GMT -03. If I try using another function to set timezone, local processing is used. But query macro has worked for me. I have tried _seconds_between( # timestampMask ...

RE: Block Local Query Processing

Posted By JEAM COELHO Sun October 09, 2022 07:21 PM
Found In Egroup: Cognos Analytics \ view thread
Hi Nigel, Thanks for your help. Function _seconds_between( ) works when the two fields are from dataset. But, if I try _seconds_between( current_timestamp ; Start_Date ), local processing is done. The data module made by an user is doing exactly this, using current_timestamp. Is there ...

RE: Block Local Query Processing

Posted By JEAM COELHO Fri October 07, 2022 12:46 PM
Found In Egroup: Cognos Analytics \ view thread
Hi Nigel, I have not opened a case because I'm using CA 11.2.1 and I'm not sure if this issue was fixed in CA 11.2.3. So, this specific issue with time fields in datasets is simple to reproduce. Look: - There are two simple datasets that are joined by Key field. - Dataset 1 has two time fields: ...

RE: Block Local Query Processing

Posted By JEAM COELHO Fri October 07, 2022 12:25 PM
Found In Egroup: Cognos Analytics \ view thread
Hi Philipp, Thanks for your reply. In this case I'm just using datasets with data modules. We have more than 1,000 author users and is too hard to force them to user best practices always. I wanna block local processing to force using best practices or, in case of issue in CA, report to IBM. ...

Block Local Query Processing

Posted By JEAM COELHO Wed October 05, 2022 03:08 PM
Found In Egroup: Cognos Analytics \ view thread
Hi all, As everybody knows, local processing can degrade severely the environment performance. Many functions that users can consume in reports, dashboards and data modules are not push down to database engine. Currently, in my case, I have many users that are using date functions in data modules ...

RE: Discrepancies between Cognos Administration and Activities (v11.2.1)

Posted By JEAM COELHO Thu July 07, 2022 09:54 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, Patrick. I have opened a case for this kind of issue in activities. IBM has planned a fix in 11.2.3 and 11.1.7 FP5 PH31626 COGNOS ANALYTICS 11.1.X MY SCHEDULES AND SUBSCRIPTION PAST ACTIVITIES AND SCHEDULES IN GLASS UI NOT IN SYNC LEGACY UI CA 11.2.3 and CA 11.1.7 FP5 ...

RE: DPR-ERR-2019. The dispatcher cannot service the request at this time.

Posted By JEAM COELHO Mon June 20, 2022 04:35 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, This message is because your APP tier/dispatcher is initializing, after a crash, for example. It could be happen because you may set less memory to WLP in your Cognos Configuration. Default is 8GB, that is too low for production environments. Try increasing memory that can be used: ...

RE: The data item... contains an operation across 2 fact streams and involves detail items.

Posted By JEAM COELHO Fri June 10, 2022 07:08 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, Are you using DQM package? Did you try creating formula like total([Response Count]) / total([Request Count]) ? And then setting aggregation to Calculated. ------------------------------ JEAM COELHO Cognos Solution Architect LinkedIn: https://www.linkedin.com/in/jeamcoelho/ ------ ...