List of Contributions

HENK CAZEMIER

Contact Details

My Content

1 to 20 of 50+ total
Posted By HENK CAZEMIER Jan 8, 2021 12:51 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi, This applies to any location that you can edit an expression via the expression editor. FM, Reports, Calculations, Filters etc. In Compatible Query Mode expressions can be commented only via the Embedded Macro Expression and so the following are valid forms: Expression text: The expression ...
Posted By HENK CAZEMIER Dec 17, 2020 2:46 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Steven, If the expression that you're using looks something like: [ISO_THREE_LETTER_CODE] in ?iso_3_prompt? then you could change it to: [ISO_THREE_LETTER_CODE] <> '' AND [ISO_THREE_LETTER_CODE] in ?iso_3_prompt? However that would prevent you from ever finding the fields that have ...
Posted By HENK CAZEMIER Dec 17, 2020 12:50 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Adam, You are correct, fix packs are complete installs, you can install them independently. // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Dec 17, 2020 9:46 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Dario, In 11.1.7 there is a button to show the unused items from a source. See the included screen shot. // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Dec 16, 2020 9:22 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Eric, That was missed functionality, it is planned for an upcoming release. In the meantime, attached is a document with a hacky technique to address this for the time being. // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Dec 11, 2020 10:36 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jens, As far as I can tell, this code hasn't changed in years. To set up the value a call is made in jave as this: InetAddress.getLocalHost().getHostName() In my environment testing 11.0.13 gives a short name as well. If Cognos 11.0.13 and 11.1.7 are on different machines, is there something different ...
Posted By HENK CAZEMIER Dec 2, 2020 12:23 PM
Found In Egroup: Cognos Analytics
\ view thread
There are 2 APARs in the process of being fixed to address this bug. PH31567 USE OF CASE/WHEN WITH A TM1/PA CUBE CAUSES XQE-PLN-0026 FOUND UNSUPPORTED IIF FUNCTION ARGUMENTS. PH30758 AFTER UPGRADING FROM 11.0.13 TO 11.1.7FP1 REPORT FAILS WITH XQE-PLN-0020 Please refer to these in your follow up with ...
Posted By HENK CAZEMIER Nov 26, 2020 9:34 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi, In Reporting you can format the column to many different formats. I've attached a screen shot of where to find this item. You can also assign a format in the modeling tools, either Data Modules or Framework Manager. Please let me know if that's not quite what you had in mind. // Henk ----------- ...
Posted By HENK CAZEMIER Nov 23, 2020 5:19 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Dale, Glad to see that you worked it out by using the property of a level. Also, you can use the caption function to get the string representation of a level. E.g. caption([some_level]) + caption( [some_other_level]) // Henk ------------------------------ HENK CAZEMIER -------------------- ...
Posted By HENK CAZEMIER Nov 21, 2020 12:10 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Leif, One way that you can do this is: select the table object where the measure is defined add a calculation set it's expression to the value of the baseline select this new calculation and set its usage:measure and aggregation:minimum add this new calculation to the y-axis box of the vis. Please ...
Posted By HENK CAZEMIER Oct 28, 2020 9:54 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jennifer One way to do this is by creating a <union>, with <preserve duplicates> so that the data looks like: ID Activity Date account123 3-1-2020 account456 Null account123 1-1-2020 account456 ...
Posted By HENK CAZEMIER Oct 21, 2020 10:21 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jeremy, Sorry about that section of the document not being as clear as it could be. I will log a bug with documentation. The snippets that are shown in the dimension tables, are of a different area in the table then what is shown in the report result. The concept however is not too far off. I've attached ...
Posted By HENK CAZEMIER Oct 15, 2020 12:50 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Ednei, In Dashboarding and Web-based modeling, select the age column and from the action menu (vertical …) use the <Create data group...> entry. // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Oct 14, 2020 11:44 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Elihu, This is a known issue that was introduced in Chrome 86. Dev teams are currently working on addressing this. Seems that the only recourse at this time is to use a different browser. //Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Sep 25, 2020 11:06 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Bastiaan, Could you show the definition of the query items in each of the CQM packages that you're trying to join. Are you creating a view for one of the CQM packages so that you can join that view to the second CQM package ? And could you show the join expression dialog as well ? It almost seems ...
Posted By HENK CAZEMIER Sep 4, 2020 12:31 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jeremy, Instead of creating a <view>, you could create a <joined view>, you'll have to enter the relationship between the tables once more, because a <joined view> owns its relationship. The advantage would be that you wouldn't have the extra filter definition laying around and the ...
Posted By HENK CAZEMIER Aug 27, 2020 12:42 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, Thank you for providing that feedback. This item has been added to the list of 'papercuts', i.e. items that if done a bit different, would allow for better productivity. // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Aug 21, 2020 2:41 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, The loading of the data set that I'm referring to is the phase when the query is posed against its sources (databases, uploaded files, other datasets) and is used to create a resultset that is loaded into the data set. This step is initiated from the <save and load> action in the data ...
Posted By HENK CAZEMIER Aug 21, 2020 1:18 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Buddhi, The generation of MDX is done for crosstab-like queries, this could be for a crosstab widgets, but also for charts that are part of the report. For datasets, the MDX is processed by the Cognos Server. There is no setting that allows you to disable that. // Henk ------------------------------ ...
Posted By HENK CAZEMIER Aug 21, 2020 12:32 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Ravindra, Here is some additional info that will help to explain what you're observing: Data sets are processed on the Cognos Analytics server. The underlying technology is a Parquet file. The queries are processed by a separate java process. The queries and results are cached for a duration ...