List of Contributions

HENK CAZEMIER

Contact Details

My Content

1 to 20 of 50+ total
Posted By HENK CAZEMIER Jul 2, 2020 11:51 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Boddula, Sorry to hear about the difficulty that you're having with this scenario. I checked our defect system and there was a reference to a similar issue around 2015, but that was fixed. This leads me to believe that this is a different issue. Please log a bug. // Henk ------------------------------ ...
Posted By HENK CAZEMIER Jun 26, 2020 11:35 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, What is the message that you're seeing. Is there a small-ish sample report that you could share? Thanks // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Jun 25, 2020 12:09 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Melody, Please have a look at the information here: https://www.ibm.com/support/pages/output-wraps-multiple-rows-excel-2007 https://www.ibm.com/support/pages/excel-2007-outputs-do-not-reflect-size-and-overflow-settings-html-outputs-do // Henk ------------------------------ HENK CAZEMIER ...
Posted By HENK CAZEMIER Jun 22, 2020 9:29 AM
Found In Egroup: Cognos Analytics
\ view thread
Starting with 11.1.6 when you hover over the item, in the properties pane of the visualization, it will bring up a fly-over with the path. // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Jun 9, 2020 12:48 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Melody, That's an interesting little puzzle. Cognos does not provide a simple function for this. So we need to use what is available. This is a scalar operation on a date. That makes it at least a low-cost kind of operation. You also need to define what you call the first day of the week, is that ...
Posted By HENK CAZEMIER Jun 3, 2020 3:27 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Betina, There could be a couple of reasons: 1 - set the query property: auto-group-and-summarize to yes 2 - does the layout element of the list have a properties collection defined that is adding an extra data item ? If you look at the generated Cognos SQL, is there an unexpected entry in the GROUP ...
Posted By HENK CAZEMIER May 20, 2020 2:48 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Stoyka, This value is controlled by a governor. The idea was to avoid run-away queries, because the in-list were too long, the reported one was many times larger. There is a between option as well, that might work. The other option is to define another value, there are a couple of places. Is this ...
Posted By HENK CAZEMIER May 3, 2020 12:41 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Thomas, I'm sorry to see you're having a this issue. I just checked the code and unfortunately there is a difference in behaviour between Compatible and Dynamic Query Mode. I would recommend that you log a bug for this. I'm not sure if there is a way to workaround this issue, short of going back ...
Posted By HENK CAZEMIER Apr 27, 2020 12:44 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, What is the kind of datatype change that you're making ? Data Modules expose a higher level data type, that groups similar underlying data types into the same category, e.g. short, int, long all are INTEGER varchar(10) , nvarchar(10), char(10), 10 representing any number, these all become ...
Posted By HENK CAZEMIER Apr 24, 2020 3:36 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, Using CA 11.1.6, Modeling UI, this works well. I was adding/removing columns to [ Country - View (1)]. You can use the new 'Custom Table' Perspective, select the node and there is an action menu that brings you to the table editor. (There is a <- arrow at the top of this screen to navigate ...
Posted By HENK CAZEMIER Apr 22, 2020 5:34 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, Sorry for the delayed response. Whether the with-clause governor is turned on or not doesn't make a difference with respect to the length of the projection list. In Data Modules you can control this with the recently introduced advanced property: Item List that is part of the table.properties, ...
Posted By HENK CAZEMIER Apr 17, 2020 12:36 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, It's not currently supported, but on the list of things to be addressed. // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Apr 17, 2020 12:34 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, There is no UI for controlling that aspect. Is there a specific problem that is caused by this? // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Apr 17, 2020 12:02 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Gopi, This is the kind of error that can be a bit frustrating. One approach is to narrow it down by adding the 3 new fields one at a time. This will at least identify the one new field when the issue starts to occur. Which query subject does that field come from? It is probably not from one of the ...
Posted By HENK CAZEMIER Apr 16, 2020 12:02 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, I can confirm that the limit is 5,000 characters. There is no configuration or other setting that allows this to be changed. From a point of interest: what kind of data are you looking at? What kind of functionality would you leverage to work with data? // Henk ------------------------------ ...
Posted By HENK CAZEMIER Mar 23, 2020 11:24 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi David, The percentage operation that you're looking for is only available when you're using a dimensional source, e.g. an OLAP cube or a Dimensionally Modeled Relational source defined in a Framework Manager model. The UI of Reporting would look like: If you're using a relational source, modeled ...
Posted By HENK CAZEMIER Mar 16, 2020 4:03 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Alex, I was able to reproduce the issue that you reported. Confirming your observation: the format that you specify in the Data Module is not how it treats the input, but it specifies how it is rendered. I would consider this a bug. It seems to treat favour the mm/dd/yyyy parsing, but when it fails ...
Posted By HENK CAZEMIER Mar 16, 2020 9:27 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Alex, Which version of Cognos Analytics are you using? Could you attach the file as well please? // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Feb 27, 2020 9:43 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, I'm using CA 11.1.5 and the screen tips of a query subject and that of a query item get copied to the table and item in the data module when I create a view of a table in that FM package. No advanced settings are needed. Are you on the same version ? // Henk ------------------------------ ...
Posted By HENK CAZEMIER Feb 26, 2020 3:14 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, Current support in Data Modules for parameters is very limited, because the Modeling UI doesn't (yet) support prompts for parameters. Using the macro function ParamValue will allow you to work with parameters, but it has one big difference with the prompt and promptmany macro function in that ...