User Defined Functions
User defined function or UDF are the customized business logic functions which users can use in the generation of analyses. These functions let users get any kind of analytical information from Baan.
Types OF UDF
User can attach UDF to each analysis. UDF can be of 2 types viz. Query fields and Boolean logic. Query fields can be used as query fields while defining the query fields for an analysis . This (return value of the function) will come in the output as dimension /measure . Boolean logic is used to test the each extracted records against the logic. And only if the return value is true ,the extracted record will be considered for analyses. Thus boolean logic is additional user defined filter on extracted data based on program logic written for the boolean function .
UDF Return Data Type & Domain
Each UDF should have return data type. If the domain is tcbool, then user can make the custom logic a boolean logic by making the UDF return type as Boolean.
User has to specify the valid domain in UDF Return Domain . UDF return data type is the data type of UDF Return Domain. UDF return data type can be accessed only the UDF return domain is tcbool.
User can maintain 2 text viz UDF and UDF Help . Maintaining UDF is mandatory. In UDF user can write any valid Baan code , select data from any tables , use any baan functions .
Once the UDF is maintained, the user has check the logic. If UDF code is error free , field 'Checked' is set to yes .Only the checked UDF can be used in analysis. UDF will never give an error if the program logic is in accordance with rules of Baan 3GL programming and Baan 4GL functions .
UDF Parameters
User can maintain parameters from the data source for the function and then those parameters can be used in UDF . Data source can be a Baan table or Baan report layout .
This session can be used for data source based on table and based on report only .
UDF Text
UDF Link to Analyses
The user defined functions so created and checked ok are available for selection as query fields / dimension / measure in the analysis. User can select CTRL + E in Analysis on table for available UDF’s and CTRL+A in analyses based on report.
UDFs virtually lets user do/ write anything within Baan using Baan 3GL code . One can write any
Baan 4GL powerful functions and any number of SQL queries.
FastTrack to ERPJEWELS :
Latest Trend | Hot Links | Jewels of ERPJewels | Jewels of Baan | Jewels of Excel