List of Contributions

David Kristensson

Contact Details

My Content

1 to 10 of 10 total

RE: Stacked bar chart (old version) is not showing colors on Mac or Iphone

Posted By David Kristensson Wed October 04, 2023 01:29 AM
Found In Egroup: Cognos Analytics \ view thread
Thank you again for your efforts. It is the old charts I am using but I haven't been able to solve it. Have been busy with other work and not tried very hard but would really like to find a solution. I will try again with different properties and palettes. Perhaps in Cognos 12 everything will work as ...

RE: Stacked bar chart (old version) is not showing colors on Mac or Iphone

Posted By David Kristensson Tue September 26, 2023 01:42 AM
Found In Egroup: Cognos Analytics \ view thread
Hi and thank you for your reply! Aha so it has been a problem for that long. Strange that it keeps coming back like after the latest MacOS upgrade. I tried to change the palette to a more simple one and got this strange result. The colors are shown in the legend but not in the bars. ...

Stacked bar chart (old version) is not showing colors on Mac or Iphone

Posted By David Kristensson Fri September 22, 2023 07:33 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, After some of our users upgraded their Macbooks the pdf version of one of our reports no longer works. We have seen the same problem in our smart phones before but did not try to solve it. Now the problem is bigger. I tried to create a new ugly report with stacked bar chart and we see the problem ...

RE: How to Unhide Labels in Cognos Dashboard When Viewing in Smaller Screen Size?

Posted By David Kristensson Fri September 01, 2023 02:20 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Aiman, I believe you are looking for one of the properties for the vizualisation. Under the chart section the property "Responsive" is defaulted to on. Switch it to off and the labels should be visible for you. Regards, ------------------------------ David Kristensson ...

RE: Calculate percentage between 2 values ​​in the same column, per month

Posted By David Kristensson Wed August 30, 2023 01:54 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, Patricks solution is one way. If you don't want the multi-query report you could do it like this. The Consumer data item only includes the consumer data like this: The Total data item only includes the Total data like this: Then the third data item called Percentage ...

RE: Simple sorting isn't simple?

Posted By David Kristensson Thu November 11, 2021 04:01 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, I have also been very frustrated about this issue and I don't think that it is possible with the new visualizations. It has forced me to sometimes use the old charts instead of 11.1 Visualizations and that is really annoying. What version are you at? I was hoping that it has been included in newer ...

RE: XQE-PLN-0026 Found unsupported IIF function arguments

Posted By David Kristensson Mon November 30, 2020 10:20 AM
Found In Egroup: Cognos Analytics \ view thread
No, we never did and have not tried after that either. Strange that this issue hasn't got any attention. Perhaps you should contact support if you really need it to be solved. Br, David ------------------------------ David Kristensson ------------------------------

RE: Reloading Data Sets based on Triggers

Posted By David Kristensson Wed October 07, 2020 02:17 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, In our 11.1.7 environment we can create a job including both dataset reloads and reports directly by clicking the dataset itself or by using the "New job" option. I tried to find it in Cognos Administration after that but that is not so easy. However it can be added as a step to one of our jobs ...

Connect to Db2 Warehouse on Cloud from local Db2 Client sql1109N gskit error

Posted By David Kristensson Wed September 09, 2020 07:52 AM
Found In Egroup: Db2 \ view thread
Hi, Getting error: SQL1109N The command was not processed because the database manager failed to load the following DLL: "GSKit Error: 8". SQLSTATE=42724 when trying to connect to an alias with SSL I have added paths to the GSK kit in variables LIB, LIBPATH and PATH but still no success. ...

XQE-PLN-0026 Found unsupported IIF function arguments

Posted By David Kristensson Tue September 01, 2020 09:45 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, After upgrading from 11.1.3 to 11.1.7 some of our reports and also some measures in our dynamic cubes stopped working. I have found the cause of the problem to be our CASE WHEN statements. After changing them to IF THEN ELSE it works. But in some cases when there are many possible outcomes it ...