List of Contributions

HENK CAZEMIER

Contact Details

My Content

1 to 20 of 50+ total
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 26, 2020 9:34 PM
Found In Library: Cognos Analytics
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 Nov 21, 2020 12:10 PM
Found In Library: Cognos Analytics
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 21, 2020 10:21 PM
Found In Library: Cognos Analytics
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 ...
Posted By HENK CAZEMIER Aug 19, 2020 10:42 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Todd, That is a bug, should not occur. Please log it as an issue. Are you able to get a bit more info from this error, e.g. a stack-trace. If so please send it to me. There might be a way to work-around this. Also please indicate the version you are using. Under normal circumstances outer joins are ...
Posted By HENK CAZEMIER Aug 12, 2020 11:29 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Glen, You can use aggregate:string_agg([ns].[sales].[sales_order], ', ' ) I checked this in Report Studio using a Data Module that uses the Country table object. Country expression: substring([C].[C_gosales].[COUNTRY].[COUNTRY],1,1) IsoThreeLetterCode expression: aggregate:string_ag ...
Posted By HENK CAZEMIER Aug 12, 2020 9:24 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Chandra, That is a current restriction in the product. The only way that I know of working around this is: create a Data Module and add a reference to each of the FM Packages. Then base the report on this Data Module. Another way is to create a dataset for each of the queries of the FM Package and ...