List of Contributions

HENK CAZEMIER

Contact Details

My Content

1 to 20 of 50+ total
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 ...
Posted By HENK CAZEMIER Feb 20, 2020 12:06 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Camilo, It is likely that the value is not NULL, but instead is empty or just spaces. When you look in the grid view, does it show NULL or an empty cell ? If it shows NULL then the above should have worked, in that case maybe you can send me a sample xlsx file that has the problem. Which version are ...
Posted By HENK CAZEMIER Feb 20, 2020 9:02 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi David, What is the expression for the filter? Have you tried adding a test for null, e.g. OR animal_col IS NULL ? // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Feb 19, 2020 9:56 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Brenda, Could you show me the whole filter expression ? I'm not aware of any issue with the in_range operator, but I will have a look. Thanks, Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Feb 14, 2020 3:40 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jennifer, This is a bug in the system. We suspect that the behavior fluctuates depending on cached vs. non-cached data and re-using result sets. One thing to try is to set use-local cache to false for that report and see if the behavior becomes consistent. In any case, you should log it as a bug. ...
Posted By HENK CAZEMIER Feb 13, 2020 8:38 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Mark, You can model this either using Data Modules or Framework Manager models, the principle is the same. I'll use the Data Module Terminology. The lookup-table in raw format say it's defined as LTRaw(col1, col2, code_col, description, col5, col6 etc). Select this table and from the context menu ...
Posted By HENK CAZEMIER Feb 3, 2020 1:09 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Richard, The list changes a bit from release to release. In essence any crn:parameter entries at the top-level of the <install>/configuration/cogstartup.xml on the cognos server can be retrieved this way. Note that some of those entries are more complex than a simple string. // Henk ------ ...
Posted By HENK CAZEMIER Jan 31, 2020 1:33 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Richard, In the expression editors of Cognos Analytics there is function list that describes the available macro functions. Here is a screen shot of the web-based modeling tool when defining a calculation. I hope this answers most of your questions, but please feel free to reach out for further info. ...
Posted By HENK CAZEMIER Jan 30, 2020 10:38 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Hakkim, When using the Dashboarding tool you can not build composite queries like you can in Reporting right inside the tool. Instead, you would be using the web-based modeling tool, which starting with version 11.1.5 has a new perspective that gives a diagram view of the 'Custom tables' as these ...
Posted By HENK CAZEMIER Jan 29, 2020 11:04 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Richard, The following macro expression: #sq(getConfigurationEntry('externalDispatcher'))# gives you something like: 'http://laptop-p52henkc:9400/p2pd/servlet/dispatch' Is that something that you can work with? // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Jan 14, 2020 2:37 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Dino, With regards to: Can the default _as_of_date be changed (not hardcoded, it should be passed from other column) or paired in any way that it does not reference on "Today" ? As mentioned in a previous message, the user can change the global parameter. Another way would be to create a Date ...
Posted By HENK CAZEMIER Jan 13, 2020 4:22 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Kenneth, The query ends up using a collection of tables/queries that are not connected via a relationship/join. [Report Tables].[Dim_Rpt_Minutia], [Report Entry Tables].[Dim_Rpt_Entry_Custom_Lang], [Report Entry Tables].[EXPENSE_Dim_Expense_Type_Lang], [Report Entry Tables].[Fct_Expense_Journal], ...
Posted By HENK CAZEMIER Jan 13, 2020 4:15 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Dave, The following should work: if ( workorders.Complete_Date>workorders.Target_Date) then ( 1) else (0) My personal preference is to use case statements instead, because there are fewer parenthesis to deal with. case when workorders.Complete_Date>workorders.Target_Date then 1 else 0 end Currently(11.1.5) ...
Posted By HENK CAZEMIER Jan 7, 2020 2:37 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Nischhal, Could you share the report spec or send it to me. henk.cazemier@ca.ibm.com // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Jan 7, 2020 1:49 PM
Found In Egroup: Cognos Analytics
\ view thread
Ni Nischhal, Please have a look at the aggregation for PTD, it should probably be total //Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Dec 6, 2019 2:18 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Samuel, try something like this: substring( '00000000'+cast (cast( COUNTRY_CODE, decimal(10)), varchar(10) ), octet_length ( '00000000'+cast (cast( COUNTRY_CODE, decimal(10)), varchar(10) )) - 7,8) //Henk ------------------------------ HENK CAZEMIER -------------------------- ...