List of Contributions

René Kent Nielsen

CogniTech A/S

Contact Details

CogniTech A/S

My Content

1 to 20 of 48 total
Posted By René Kent Nielsen Mon February 05, 2024 02:48 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, If i read this correct the ?pSnapshotdate? is in the FM package filter, then it will always be mandatory. Don´t you have access to the FM package ? And what version of Cognos Analytics is you running ? #IBMChampion ------------------------------ René Kent Nielsen Brand manager ...
Posted By René Kent Nielsen Tue January 30, 2024 04:27 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, The filter would be [Departure Date]>= [DepDateFilter] or [Departure Date]< [DepDateFilter] But it will return every [Departure Date], so why would you use a filter ? #IBMChampion ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------- ...
Posted By René Kent Nielsen Mon January 29, 2024 02:30 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, Put you if statement in a query object insted, lets call it DepDateFilter : if (? Parameter1? =1) then (_add_days(current_date;-1) ) else (?p_SnapshotDate?) And then the filter would be : [Departure Date]>= [DepDateFilter] I don´t get the 2 or in you filter, it will return all dates ...
Posted By René Kent Nielsen Wed January 17, 2024 02:04 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, What source are you using cube or datamodule ? #IBMChampion ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Thu September 07, 2023 02:58 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi JH I build a HTML list visualization for the purpose, you can customize it, after your needs. You can find the custom visualization on our website : Html table - visualisering i Cognos Analytics (cognitech.dk) #IBMChampion ------------------------------ ...
Posted By René Kent Nielsen Thu August 17, 2023 02:47 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Pavithra, You can create a dataitem like this in your prompt query min([Date] for [YearMonth]) and exclude weekends and holidays in your filter. and set that as use value and still have the [YearMonth] as display in the prompt Where [Date] and [YearMonth] comes from ...
Posted By René Kent Nielsen Wed July 19, 2023 02:28 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, Done upgrades from windows server 2012 -> 2017 and 2012 -> 2019, both without any problems. Stop the Cognos service before the upgrades, and make sure to install the upgrades with the same language / region settings. After the upgrade, start the Cognos services again, no ...
Posted By René Kent Nielsen Tue July 18, 2023 02:28 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, You have 2 easy options. You can switch the report to not run with full interactivity Or Create a block first and put the value prompt inside it #IBMChampion ------------------------------ René Kent Nielsen Brand manager ...
Posted By René Kent Nielsen Wed June 28, 2023 03:34 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Frans Be sure to empty the browser cache after upgrade. I´ve seen that a lot, after upgrading, and it needs to be the entire cache not just for last 24 hours or so. If thats not working, make sure you also upgraded the IIS with the setup script. Br Rene ...
Posted By René Kent Nielsen Wed April 12, 2023 03:12 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, Yes, you can use the parameter provided in a prompt, in a boolean variable if its false set boxe type to none, if it is true leave box type as default. #ibmchampion ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Wed April 12, 2023 01:48 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, You can use a variable with the box type set to none if the variable is true/false Hope that helps :-) ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Wed February 01, 2023 11:29 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Chris, Under roles you able to enable and disable features, from here you can control tabs in your extension. Br Rene ​ ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Wed February 01, 2023 06:48 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Chris, You can use the roles in Cognos, to customize what the portal look like and contain for the user that have the roles you customize. Br René #ibmchampion​ ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ----------------------------- ...
Posted By René Kent Nielsen Tue October 04, 2022 02:17 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi You will have data from both security groups, if you don´t use deny in the security, deny always overrules a in security. Br ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Wed September 28, 2022 03:44 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, I think the only way, is to "kill" the sessions on your SQL server, it needs to clean up in temp etc. that´s way it take a short time to close the sessions. Br ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Tue August 02, 2022 02:12 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi You could use prompt macro for this, i could be with a token as datatype, like this #prompt ( 'Global Budget Month' , 'token' , 'AUG' )# Br ​ ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Tue May 31, 2022 02:20 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Take a look at cogbox, in the free version you have pdf and excel export Br René ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Mon April 25, 2022 01:59 AM
Found In Egroup: Cognos Analytics
\ view thread
HI, Only the cubes metadata is loaded in memory as default, so all the transactions is in the database, and can be in various summery tables, so the Dynamic Cubes rely on at good database set up, for best performance, and have no maximum size. Br René ------------------------------ René Kent ...
Posted By René Kent Nielsen Thu April 07, 2022 01:54 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Nickolus, The on demand link is not working. Br René ------------------------------ René Kent Nielsen Brand manager CogniTech A/S Herning ------------------------------
Posted By René Kent Nielsen Fri October 29, 2021 02:34 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi 1) Datasets are stored in the content store, and disk/memory. Example :If you restart the Cognos service it will load from the ContentStore into disk/memory, a number of datasets will be in-memory It is possible to fine tune : https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=sets ...