Can anyone tell me if it is possilbe to add more functions. I need to add Mode as a statistical function.
bp0521 (BOB member since 2009-11-11)
Hi:
Yes its possible.
Each data access driver is associated with a SQL parameters file (.prm). The PRM file contains default SQL parameters used for query generation, date and other operators and functions.
The PRM files are located under:
c:\Program files\Business objects\Business Objects_Enterprise 11.5\win32_x86\dataAccess\connectionsServer<RDBMS>\ directory.
If you are in later versions, go through appropriate version directory.
Review the existing functions in the respective RDBMS prm file.
Open the .prm file in the text editor or XML editor.
Copy the existing function and modify according to your new function.
The function will have following info needed:
Group: This group tag specifies if the function needs to generate a GROUP BY.
ID: The ID represents the unique identifier for the function across all PRM files.
InMacro: the InMacro tag specifies if the functions apears in the function list in an object’s Edit select box in Designer.
Type: This represents the function return type.
Arguments: represents the arguments accepted by the function.
SQL: This represents the SQL syntax for the function.This is also the name that appears in the function list in Designer.
You can also add help text for the new function under .prm file (example: oracleen.prm).
Save the files.
Relaunch the Designer and check out the new function is listed.
Hope this helps.
Regards
Ramesh Vasudevan.
rameshbalajiv (BOB member since 2008-03-25)
You can add a function only if it is supported by the corresponding RDBMS.
Rakesh_K 
(BOB member since 2007-12-11)