Hi Vabhav,
Specifically addressing Macro Functions:
Cognos Analytics:
https://www.ibm.com/docs/en/cognos-analytics/10.2.2?topic=SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_fm.10.2.2.doc/c_macro_functions.html
An additional outside source for Macro Functions::
Macro Functions:
https://bi-solutions.gaussling.com/macro-functions-in-cognos-report-studio/
Creating Custom Report Functions:
https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=ccrffs-creating-custom-report-functions#cstmfnctns_creating_report_functions
Creating Custom Report Functions and Function Sets:
https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=sdkdg-creating-custom-report-functions-function-sets
An excellent source of information in terms of calculating business hours between two dates, the following link provides options to calculate your start and end dates. It also provides suggestions on simplifying the processes of creating your user defined functions.
https://www.cognoise.com/index.php?topic=25142.0
There is a process you go through in IBM in creating and calculating start and end dates. The above stated links will guide you in the right direction.
I found the information on creating report expressions helpful because some expressions are available by default, such as Today(), ReportDate(), ReportName(). There's also a section on defining functions, identifying functions in the function definition service, and then creating custom functions (user defined).
I sincerely hope this helps Vabhav.
Yvonne
------------------------------
Yvonne R. McGinnis
DevOps (hopeful), Systems Administration
Obama Foundation, Chicago
Chicago Cato, Illinois
773-886-5579
------------------------------
Original Message:
Sent: Tue April 13, 2021 06:35 AM
From: Vaibhav Pujari
Subject: User defined functions
Hi,
We want to create a user defined function in cognos, which will calculate the business hours between 2 dates.
The parameters to the function will be - StartDate, EndDate, fromTime,toTime,NoOfDays
Is there a way in cognos to create a user defined function or a macro function?
Thanks,
Vaibhav
------------------------------
Vaibhav Pujari
------------------------------
#CognosAnalyticswithWatson