List of Contributions

Robert Dostal

GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG

Contact Details

GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG

My Content

1 to 20 of 50+ total

RE: Change the background color of the Cognos Welcome Banner in V12.

Posted By Robert Dostal Mon April 22, 2024 12:02 PM
Found In Egroup: Cognos Analytics \ view thread
Hi John, if you have an on-premise installation the file mentioned is stored here: ..\analytics\webcontent\bi\css\ca-content ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG Ingelfingen ------------------------------

RE: Calculate YTD Average handling for NULL data

Posted By Robert Dostal Mon April 22, 2024 02:31 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, sounds realistic to me. average is a calculation that computes sum(measure) / count(measure). Null is not an instance of an element/measure and won't be counted. 40+45 / 2 = 42.5 45 / 1 = 45 You have written that you handel NULL values with the coalesce function and replace NULL with ...

RE: 12.0.2 unstable performance in dashboards

Posted By Robert Dostal Fri April 19, 2024 09:34 AM
Found In Egroup: Cognos Analytics \ view thread
Nope, it's a on-prem installation of V 11.1.7 FP7 but I just wanted to mention that we see that recurring spill up of CPUs from time to time. So far it seems like nothing to do with data but with metadata read from models. ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller ...

RE: 12.0.2 unstable performance in dashboards

Posted By Robert Dostal Fri April 19, 2024 08:34 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Sandeep, have you monitored the server resources during these waiting times? We have a similar recurring issue that we have not yet been able to nail down to a distinct reason. It shows up randomly that the server CPU consumption goes up to 100% on all cores and stays that for about 30-60 seconds ...

RE: What would "perfect" Cognos Analytics?

Posted By Robert Dostal Thu April 18, 2024 04:29 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Patrick, another very nice touch would be to have syntax highlighting in Reporting query items (already available in dashboard calculations). Waiting for this for ages now..... ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG Ingelfingen ...

RE: Display a LIST only after selecting 2 parameters, without creating a prompt page

Posted By Robert Dostal Thu April 18, 2024 02:22 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Gustavo, as I've understood you need a combination of a conditional block with a variable that checks parameter values. Drag a new conditional block at the position where the list is. Then go to variables. You will need to create a boolean variable that returns yes only when both drop ...

RE: Inconsistent / Missing Visualizations in Cognos Analytics

Posted By Robert Dostal Tue April 16, 2024 02:42 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, if it is the exact same data source with no changes at all - that's a very strange behaviour. Have you already tried to reset the browser cache and/or use a different browser? ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG Ingelfingen ...

RE: Planning Analytics cube as a data source in Cognos Analytics

Posted By Robert Dostal Fri April 12, 2024 03:34 AM
Found In Egroup: Cognos Analytics \ view thread
Hi @Jaakko Forsberg, yes, that's for on-premise installations. I haven't looked up the documents for the cloud licenses. Follow the link I've posted above and you can search for the part numbers you have licensed. That is very important because license documents do change from version to version. We ...

RE: Planning Analytics cube as a data source in Cognos Analytics

Posted By Robert Dostal Thu April 11, 2024 06:00 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Jaakko, I can only give you some hints about licensing and what kind of confirmations I have here from IBM. The wrap up is that the licensing program is the UI you are use to access the data. That means if you have your 10 CA licenses, they are allowed to also use reports and dashboards which ...

RE: Cognos 11.2.4 UI Changes

Posted By Robert Dostal Thu April 11, 2024 05:14 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Paul, will the modified "Recent menu" be part of the premium version of CogBox? ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG Ingelfingen ------------------------------

RE: What would "perfect" Cognos Analytics?

Posted By Robert Dostal Wed April 10, 2024 03:26 AM
Found In Egroup: Cognos Analytics \ view thread
Don't know if my second posting got deleted or if I missed the "Post" button, but I also recommend to have a look at IBMs own portal for customers to log enhancements: https://ibm-data-and-ai.ideas.ibm.com/?project=CA ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller ...

RE: Can a report template contain a report expression

Posted By Robert Dostal Thu April 04, 2024 10:54 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Brenda, afaik no report template can contain any type of query and therefore no expression or SQL. I have the same requirement for our report to contain some data. I've create a report which is available to the public that contains a public data source with just one table in it that contains ...

RE: Cognosv12.0.1 Package-Based Drill-through

Posted By Robert Dostal Wed April 03, 2024 05:17 AM
Found In Egroup: Cognos Analytics \ view thread
IBM Support logged a defect for this issue as "PH60653 MISSING SCOPE ENTRY OPTION WHILE CREATING DRILL-THROUGH DEFINITION FOR PACKAGE". It has been submitted to the dev team for further investigation. ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller Apparatebau GmbH & ...

RE: Cognosv12.0.1 Package-Based Drill-through

Posted By Robert Dostal Tue April 02, 2024 10:37 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Syd, IBM Support confirmed that it is a bug. An APAR will be created. I'll post it when it is published asap. ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG Ingelfingen ------------------------------

RE: What would "perfect" Cognos Analytics?

Posted By Robert Dostal Tue April 02, 2024 10:35 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Austin, here are my top 3 points: Modernize Dynamic Cubes and bring them into the Glass UI (e.g. Data Modules) It would be great to have the modelling capabilities from the Cube Designer integrated into Data Modules and also do add some features which should be standard (e.g. transfer parts from ...

RE: Cognosv12.0.1 Package-Based Drill-through

Posted By Robert Dostal Tue April 02, 2024 02:48 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Syd, yes you're right, the entry is missing also on my system. Will open a ticket at IBM Support for further investigation. ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG Ingelfingen ------------------------------

RE: Aggregate: and Linear Regression Functions

Posted By Robert Dostal Thu March 28, 2024 03:58 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Marc, you cannot use Cognos data items between ( ). All elements have to be named like in the native tables like you wold have written manually in SQL. I've never used these kind of Oracle functions but your expression ( REGR_SLOPE( [Revenue], [Year] ) ) should be translated into ( REGR_SLOPE( ...

RE: Aggregate: and Linear Regression Functions

Posted By Robert Dostal Wed March 27, 2024 08:59 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Marc, have you tried to bypass pure SQL code into the generated code by using ()? Everything between ( and ) gets send 1:1 to the database and is not interpreted by Cognos. I use this trick to sqeeze a subselect into where-clauses like. ------------------------------ Robert Dostal Team Leader BI ...

RE: created a dashboard template but does not appear as custom tab in new dashboard

Posted By Robert Dostal Fri March 22, 2024 06:26 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks for the update. Am working with Cognos for so many years now and still on the learning curve :) ------------------------------ Robert Dostal Team Leader BI GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG Ingelfingen ------------------------------

RE: Use of Developer widgets in Cognos Dashboard

Posted By Robert Dostal Fri March 22, 2024 03:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Hashim, here's the link for authoring schematics: https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=developer-authoring-schematics-tutorial and here's the link for custom visualizations: https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=developer-step-by-step-guide-custo ...