List of Contributions

HENK CAZEMIER

Contact Details

My Content

1 to 20 of 50+ total
Posted By HENK CAZEMIER Nov 5, 2019 4:51 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jenifer, Could you post a collection of the string values that you're trying to convert ? The solution will likely involve a number of different functions for the various cases that are present. //Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Oct 25, 2019 1:39 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Ramón, Would you be willing to share the reportSpec, CognosSQL and NativeSQL for that report or send it to me directly ? That will help in figuring out what could be done differently to improve performance. //Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Oct 24, 2019 11:00 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Vic, The data can be in tables. From the problem statement I was under the impression that you were dealing with two tables. If it is a single table, I'm not sure how to picture that table is defined. May be you can simulate it in a spreadsheet and I'll have a better idea on how to suggest a solution. ...
Posted By HENK CAZEMIER Oct 22, 2019 11:05 PM
Found In Library: Cognos Analytics
Posted By HENK CAZEMIER Oct 22, 2019 11:05 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Vic, Attached is a spreadsheet file with the data and a document with instructions on how to achieve the results that you're after. I used Cognos Analytics 11.1.4. In previous versions you should be able to do the same. You can also upload the spreadsheet, create a simple data module and then create ...
Posted By HENK CAZEMIER Oct 16, 2019 1:57 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Nick, The link should be working now, please accept our apologies. //Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Oct 3, 2019 10:13 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Richard, Have you looked at CAMIDListForType ( identity type ) Returns an array of the user's Cognos® Access Manager IDs (CAMIDs) based on the identity type (account, group, or role). CAMIDListForType can be used with the macro functions csv or join. Example: [qs].[userRole] in ( # csv ( CAMIDListForType ...
Posted By HENK CAZEMIER Sep 18, 2019 3:32 PM
Found In Egroup: Cognos Analytics
\ view thread
After a few one-on-one emails the conclusion is that: The underlying issue is a bug in the code that has been fixed in 11.1.4. The work-around for now is to make sure that the default output format for the user is set the HTML. Heather confirmed this. //Henk ------------------------------ HENK CAZEMIER ...
Posted By HENK CAZEMIER Sep 17, 2019 9:57 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Dagur, The following document describes some detailed steps on how this can be done. https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/t_custom_date_filters.html If you're interested in doing a rolling 6 months relative to $_as_of_date, which defaults to ...
Posted By HENK CAZEMIER Sep 16, 2019 2:03 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Dagur, I can give you a hand. Are you trying to add a filter to the Caledar definition or is it an ad-hoc instance where you want to do this? The target filter expression would look something like: <some_date_column> between current_date and _add_days(current_date,10) Thanks Henk Henk Cazemier ...
Posted By HENK CAZEMIER Sep 13, 2019 4:05 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Lisa, The attached picture has a field [code] that has some dashes in it. The field [code_1] removes the first dash from [code] The field [code_2] removes the first dash from [code_1] Sticking to standard functions only, so that it can be used for any SQL compliant database. The expression for code_1 ...
Posted By HENK CAZEMIER Sep 13, 2019 4:04 PM
Found In Library: Cognos Analytics
Posted By HENK CAZEMIER Aug 26, 2019 12:02 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jo Marie, Security is applied to the Data Source, thus when you create a security filter against this table it will always be applied. That is for direct references as well as views, joined views etc. If a table needs to be used with both security turned on as well as not secured, then creating a ...
Posted By HENK CAZEMIER Aug 24, 2019 8:25 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jeremy, What version of Cognos are you using? Is there an error message shown? I just tried it with CA 11.1.3 and it seems to work fine as a NativeSQL statement, both in FM and Data Module UI Select startup_time from V$INSTANCE returns: Aug 8, 2019 2:18:10 PM //Henk ------------------------------ ...
Posted By HENK CAZEMIER Aug 24, 2019 8:30 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi John, Have you tried something like: cast ( cast( [Paid,Employee] , decimal(10,2)) , varchar(15)) //Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Aug 22, 2019 9:43 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Krish, Does the CQM connection string look similar to the following? This works for me on a machine that is running SQL Server 2014. // Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Aug 21, 2019 1:23 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Krish, You're using the 'old-style' connection configuration pages, which allow for setting up connections for Compatible Query Mode(CQM) and Dynamic Query Mode.(DQM) It looks like your CQM connection is not working, but the DQM connection is. When you're creating models in Framework Manager, the ...
Posted By HENK CAZEMIER Aug 19, 2019 10:15 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Dagur, When you select tables, only those will be imported/refreshed. The action is not additive. Thus if the first time you select tables A, B and then later want to add tables C and D then you would need to select A,B,C,D. If that is the way you did things and it doesn't work, then there is an issue ...
Posted By HENK CAZEMIER Aug 8, 2019 9:44 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi John, Please try something like: case when [Gender]='Female' then [Paid] end //Henk ------------------------------ HENK CAZEMIER ------------------------------
Posted By HENK CAZEMIER Jul 17, 2019 12:57 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Uday, The column description of flUnit in the xml file is defined as xs:decimal, but the value is '10 m/s**2', i.e. it is really a string. In Report Studio, when adding this file as an external data file, via 'Manage external data...', there is a step: 'Data attributes', in the bottom half of that ...